A new feature in Oracle SQL Developer Data Modeler is the ability to display table and view comments directly in the ERD. So I can go from this: Normal Relational Diagram to Relational Diagram with Comments to Relational Diagram with Comments ONLY Now the cool part is that I don’t have to pick. I can use all three depending on my need. Maybe I need a dev diagram for folks in the know, another diagram…
I’ve been running version 4 for so long, that I have trouble remembering if some features are new to version 4. Well, here’s a simple feature that IS new to version 4 that I think our PL/SQL friends will appreciate. Say that you’re looking at a PACKAGE SPEC member, like a FUNCTION, and I want to ‘jump’ to the BODY implementation of said FUNCTION. Or vice versa, I’m in the BODY and I want to…
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…
