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 And ‘The Movie’ Did you notice what happens if you insert or delete lines of text in the worksheet? SQL…
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 heap structure. Or as the docs put it: index_org_table_clause Use the index_org_table_clause to create an index-organized table. Oracle Database maintains…
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 PL/SQL code, you now have what we are calling breadcrumbs in the editor footer space. Now in the the world…
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 Added parallelization option for larger doc sets Enhanced the HTML formatting a bit Select Your Object Types and Generation Options…
Update, July 2018: A reader, thanks Sabine!, noticed the Clone feature is no longer available. This IDE feature was designed for FILES in mind, and it doesn’t extend itself well when applied to our worksheet and database object in the JDev framework. 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…
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 more ‘type and read’ space for your script or statement, but you also didn’t want to lose your results grid…
“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 as the underlying optimizer inputs change. EXPLAIN PLAN output shows how Oracle runs the SQL statement when the statement was…
Ugly code, we all write it. I don’t mean bad code either, just hard to read code. Developers who haven’t figured out how to use the TAB and ENTER keys – what’s up with that? — and why is Jeff talking to himself in his Seinfeld voice again? So one of the features in SQL Developer is the Formatter. With a simple right-click (or a Ctrl+F7), you can take your code from ugly to beautiful,…
A new feature in Oracle SQL Developer version 4.0 offers to address grammatical issues with your SQL statements. We call these indicators ‘Semantic Analysis Info Tips.’ The easiest way to see one of these ‘tips’ is to try out your favorite sql statement in a worksheet: 1716460272662ec4f88a2a0_000002 Accessing the ‘Tip’ Place your mouse over the red squiggle line indicator… Once the tip is available, you can invoke the grammar ‘fix’ by clicking on the hyperlinked…
Being asked when the next version of your product is going to be released is a gut-wrenching question. The community gets excited when a new release is due – who doesn’t like new things to play with? And I’d love to tell everyone when exactly that will happen. But, the very the second I shared THE DATE, I’d be branded a liar. You see, dates slip. And being in a position to not ship product…