Someone told me today that they can’t log a support request with my Oracle Support for SQL Developer. To which I replied with, ‘Oh yes you can.” To which they replied with, ‘But I do not see it in the dropdown of my products.” To which I replied with, ‘Oh, that…’ But seriously, Yes, You CAN Log SRs on SQL Developer with MOS You just have to look for it. Voila, now enter your stuff.…
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 Bug Fixes Thank you, thank you, thank you for your feedback on the Forums, Twitter, our blogs, and any other…
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, Ask For It! So what’s the magic key sequence? It’s the same as in the worksheet when activating the Code…
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 of you out there that are using our Create and Alter dialogs. And that’s what I’m here to talk about…
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 annoying and it should be easier. So in version v4.0, you can simply ask SQL Developer to re-sort itself. I…
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 the Modeler. By default, the supplied classification types are assigned a color scheme: If you need more classification types, you…
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…