This question has come up a few times recently. One person asked how to compare 2 SQL statements at Open World. In fact, they claimed if I could show them how to do it, it would make the trip to San Francisco worth every penny. Don’t be surprised they left extremely satisfied 🙂 Then just yesterday, someone else asked how to see the differences between their code objects in the database and their file system.…
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…
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 all of them listed here. Now in previous versions of Oracle SQL Developer, we have exposed a few of these…
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.…
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 block anymore. Actually, we can’t sing either, but I digress. What started out as Project Raptor in 2005 has…
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…
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 even the smallest change can create lots of angst for the end users. However, in this case the changes were…
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…
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 and highlight all occurrences of that text. This is then automatically used as the basis of a search and replace…
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…