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, […]
New and Improved Create Table Dialogs in Oracle SQL Developer 4
You may not spend a lot of time creating tables in your database, but if you are performing that task, you don’t want your tool to slow you down. And while many of you may design your tables in a modeling solution or even code them by hand in a worksheet, there are still some […]
Increased Flexibility for Oracle SQL Developer Data Modeler Diagrams in v4
I recently talked about how you could tell the modeler to use custom classification types for your tables. But, I forgot to tell you where you could find these settings in version 4! Surprise – we moved them. Excellent… Sometimes I think developers change stuff because they’re bored or maybe even because they don’t realize […]
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 […]
More on Classification Types in Oracle SQL Developer Data Modeler v4
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 to set multiple classification types for a single table – a new feature in v4 of […]
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 […]
Defining Redaction Policies for Oracle Database 12c Data Models in Oracle SQL Developer
Oracle SQL Developer Data Modeler version 4 was released as an Early Adopter just last week. You can go download it here and read about the new features here. A snippet of those new feature release notes… Masking Mask templates can be defined and used in definition of columns with sensitive information. Support for REDACTION […]
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 […]
Floating Editors in Oracle SQL Developer v4
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. You need more screen real estate. Wouldn’t it be nice if you could drag that table viewer […]
SQL Developer v4 Quick Hit: Split Worksheets
One of the cooler features SQL Developer offers is the ‘split document.’ If you don’t know what I’m talking about, please take 90 seconds and read this short post first. Ok, well that worked well for pretty much every type of editor in SQL Developer save one – the SQL Worksheet. Let’s say you wanted […]
Reporting Enhancements for Oracle SQL Developer v4
This feature is going to be hard to cover in a single post, but I’m going to try anyway. The Reports interface received performance improvements, a few tweaks to make them easier to build, a slew of new charting options, and more visual control to tweak. Oh, it’s also available via the command-line interface. Let’s […]
Explain Plan and Autotrace Enhancements in Oracle SQL Developer 4
“Explain Plans are useless.” Yikes. Really? Don’t we spend all day looking at execution plans? To clarify, I would say that explain plans could be useless. If you do an Explain, you’re actually looking at a theoretical plan, not the ‘actual’ plan. From the docs: With the query optimizer, execution plans can and do change […]
Twitter
RSS
GooglePlus
Facebook