ThatJeffSmith

Four Minute Video Tip: Configuring SQL Developer for the First Time

You’ve just installed a new copy of SQL Developer. Here are some things you might want to change in the preferences. Notes: I said ‘fixed field’ – I meant FIXED WIDTH fonts, duh If you think you’re hearing Foreigner’s Feels Like The First Time, you’re wrong Some of the tips in blog format: fonts zebra […]

Similar Posts by Subject Areas: , , ,

How to Survive, no, Thrive at Oracle Open World

These are just my opinions, and I don’t speak on behalf of my employer. On the Facebookers this morning, noticed one of my friends was contemplating coming out to San Francisco this year to join approximately 50,000 other Oracle and Java-heads for Java One and Oracle Open World. I’m not going to try to sell […]

Similar Posts by Subject Areas:

How to Reset Your SQL Developer Preferences/Settings

We store the application settings PER user. So find where your OS stores files for your OS user. These settings are stored HERE on Windows (…AppData\Roaming\SQL Developer): They are stored HERE on Macs and *NIX ($HOME\.sqldeveloper): Find the directory that corresponds with the version you are running and having problems with. Rename it. Restart SQL […]

Similar Posts by Subject Areas: , ,

Discovering Foreign Keys in Oracle SQL Developer Data Modeler

Columbus didn’t exactly discover America. And we’re not really going to discover your long, lost foreign keys. But, we’ll do our best to guess where they might be. Our data modeling tool is often the bearer of bad news – your database doesn’t actually have any referential integrity defined. Oh, it’s defined somewhere, in the […]

Similar Posts by Subject Areas: , , ,

12c Temporal Validity Support in SQL Developer Data Modeler

Today’s question: can I design a table that takes advantage of the new Temporal Validity feature in Oracle Database 12c? Today’s answer: ‘Yes.’ In a nutshell: Temporal Validity Support lets you associate one or more valid time dimensions with a table and have data be visible depending on its time-based validity, as determined by the […]

Similar Posts by Subject Areas: , , ,

IS JSON or IS NOT JSON, That is VERY EASY to Figure Out

Working on some cool demos around JSON, ORDS, Oracle Database, JavaScript apps, etc. and I needed to load up a BUNCH of data to play with. Note the ‘other_tags’ column LOOKS like JavaScript Object Notation (JSON). There are JSON standards – should the key name and value strings be double or single quoted, etc. To […]

Similar Posts by Subject Areas: ,

SQLcl: Using the new CTAS Command

How often do you need to build a new table to test something out? How often have you typed CREATE TABLE AS SELECT… If the answer to both of those question is ‘quite a bit Jeff!,’ then continue reading. In SQLcl, we have built a new command simply called ‘CTAS.’ So let’s try it out. […]

Similar Posts by Subject Areas: , ,

On Conferences: Time to Put Tips & Tricks to Pasture?

I love performing my tips & tricks session. No two talks are alike. I frequently update the slides and content to account for new things I’ve learned and new features we’ve added. But. I’ve been delivering this talk going on 4 years now. Should I let my talk at Open World 2015 be my last […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , ,