So you’re minding your own business, doing your work, and you click in your favorite Oracle Database IDE. Do you get what you asked for? No! Instead, you are rewarded for your troubles with this puzzling and frustrating message. Abort? Try again? Busy? The Long Answer When you connect to a database in SQL Developer you are actually making two connections. We use one connection to run background queries in the the worksheet. This makes…
Another busy, crazy, awesome week is behind us. I’m going to call it a success, but before I completely file it away, I wanted to share a few quick thoughts, and say thanks to a few people for their continued support. Sunday SQL Developer Golden Gate Fun Run We had about 20 people show up – including a few crazies that ran up from the Hilton and back – and the weather was amazing. Yury…
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…