ThatJeffSmith

SQL Developer 4 and the Oracle Diagnostics Pack

Oracle Database Enterprise Edition customers have the option of extending their functionality set via various optional ‘packs.’ One of the most popular packs is the Oracle Diagnostics Pack. Funny, most people call it the ‘Diagnostic’ Pack, but it’s technically known as the Diagnostics Pack. Anyways, the pack includes a LOT of features. You can see […]

Oracle SQL Developer v4EA2 Is Now Available

EA1 dropped in July. Now here we are a little more than a week before Oracle Open World and we are making Early Adopter 2 of Oracle SQL Developer version 4 available for you to download and provide feedback. There’s two big things you need to know about: About 500 bug fixes Support for ADDM/AWR/ASH […]

10 Things You Probably Didn’t Know About Oracle SQL Developer

You think you know Oracle SQL Developer. And you probably know it better than the average user, especially if you’re a subscriber to this blog But I’m betting there’s a few key things you’ve overlooked. We’re going to fix that today! Skip Ahead to the Slideshare Version 10. We’re not the new kids on the […]

Oracle SQL Developer 4: A Tweak With Table Filter Recall

In previous versions of Oracle SQL Developer, if you start typing in the Data tab’s filter dialog on a Table Editor, SQL Developer would make suggestions for you. A few folks have asked that we not be so aggressive with the ‘help’ here. And I wholeheartedly agree. So in version 4… If You Want Help, […]

Resetting the Oracle SQL Developer Desktop in v4.0

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’ file and then restart SQL Developer. This would force SQL Developer to re-create the desktop view and bring everything back to the defaults. That’s […]

Oracle SQL Developer 4 Quick Hit: Search and Replace

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 subjective measurement, but I’m sticking with it. And something I talked about earlier, double-clicking on a ‘word’ in the editor will auto-find […]

Clickable Error Messages in Oracle SQL Developer v4

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 Developer v4, your wish is our command. Just Click on the Highlighted Blue Error Text in the Output Panel […]

How to Model an IOT in Oracle SQL Developer Data Modeler

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 Organized Table.’ The storage is organized by the index, versus say the default behavior of a […]

Oracle SQL Developer v4.0: Breadcrumbs

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 become ‘breadcrumbs.’ So what does this have to do with SQL Developer? When working with large bits of […]

DB DOC Enhancements for Oracle SQL Developer v4

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’ve introduced a few enhancements based on user requests. That’s right, you asked, and we listened. Added support for Package Bodies […]