Thatjeffsmith - thatjeffsmith.com - ThatJeffSmith
General Information:
Latest News:
Resetting the Oracle SQL Developer Desktop in v4.0 26 Aug 2013 | 09:33 pm
Can’t get your SQL History or Snippets panel to open? Before version 4.0, we would frequently advise users to close SQL Developer, go into their user settings folder and delete the’windowinglayout.xml...
More on Classification Types in Oracle SQL Developer Data Modeler v4 23 Aug 2013 | 12:09 am
We recently covered how to set the classification type of multiple tables in a data model, but today I want to show how to make these easier to identify in your model. I’m also going to show you how ...
Oracle SQL Developer 4 Quick Hit: Search and Replace 21 Aug 2013 | 07:18 pm
The new editor framework provides a more interactive and rich experience when replacing text. It’s a very simple improvement, but one that I think will make you feel ‘better.’ I know that’s a subjecti...
Clickable Error Messages in Oracle SQL Developer v4 15 Aug 2013 | 07:35 pm
So you’ve got your monster script you’re running in SQL Developer and you run into some errors. Wish it were easier to jump to the line where said errors are being reported? Well in Oracle SQL Develo...
How to Model an IOT in Oracle SQL Developer Data Modeler 13 Aug 2013 | 10:41 pm
Someone asked me how to model a table as an IOT in Oracle SQL Developer Data Modeler. But before I answer that question, we shoudld spend at least a second on just what an IOT is. It’s an ‘Index Orga...
Defining Redaction Policies for Oracle Database 12c Data Models in Oracle SQL Developer 12 Aug 2013 | 11:23 pm
Quickly ID your redacted columns in your diagrams – they are highlighted in red. Oracle SQL Developer Data Modeler version 4 was released as an Early Adopter just last week. You can go download it he...
Oracle SQL Developer v4.0: Breadcrumbs 8 Aug 2013 | 01:57 am
Hansel and Gretel are in the forest and don’t want to get lost, so Gretel leaves a trail of white pebbles to mark their way. In future adaptations of this Bros. Grimm story, the white pebbles have bec...
DB DOC Enhancements for Oracle SQL Developer v4 1 Aug 2013 | 06:57 pm
One of our more popular features is ‘DB Doc.’ It’s like JAVADOC for the database. Pick a connection, right-click, and go. It will generate an HTML documentation set for that schema. For version 4, we...
What’s New in Oracle SQL Developer v4.0 Webcast 30 Jul 2013 | 10:57 pm
You may have noticed a few posts lately where I’m talking about new and improved features in SQL Developer version 4.0. You may have also been too busy to read all of them. For shame! But that’s OK. ...
Floating Editors in Oracle SQL Developer v4 29 Jul 2013 | 08:18 pm
Working on a table? Maybe you need to investigate the stats while you also browse some data. But this is a BIG table. You know how to do the ‘split document trick,’ but that’s not quite cutting it. Y...
