Two SQL Developer Tricks: DBMS_XPLAN and Code Templates

thatjeffsmith SQL Developer 0 Comments

We recently (18.2) added a new way to generate execution plans in SQL Developer – we generate a call to DBMS_XPLAN for the SQL ID at your cursor position. DBMS_XPLAN is a package, and one of it’s procedures is ‘DISPLAY_CURSOR’: This table function displays the explain plan of any cursor loaded in the cursor cache. In addition to the explain …

Oracle SQL Developer PL/SQL Packages Trick – Synchronize!

thatjeffsmith SQL Developer 3 Comments

You know how every TV show has to have that Christmas themed episode? No? Well, in the US, it’s pretty common. And as a child of the 80’s television, my brain has been properly warped. So here is your Christmas themed SQL Developer ‘trick.’ Every look under the tree, and your first reaction is to be a little disappointed in …

Mandatory SQLDev Tip: Filter Your History

thatjeffsmith SQL Developer 2 Comments

It’s Friday! Let’s be honest though – you’ve not accomplished much this week. Monday was a holiday, emails have stacked up, lots of your co-workers are on vacation. So how can we rescue this losing scenario and turn it into a major victory? This trick will save you so much time, you’ll be mad I didn’t make you learn it …

Trick: ‘Pasting’ SQL Developer Exports to an Outlook Message as an HTML Table

thatjeffsmith SQL Developer 4 Comments

You have some data. You want to email it to someone. You don’t want them to have to open an attachment. You want it to be in an HTML-Tabl’ish delivery device. In SQL Developer, write your query. Export to HTML > File. Open Outlook. Start your message. Attach File Point to your HTML File DON’T CLICK ON THE INSERT BUTTON …

SQL Developer: Describe versus Ctrl+Click to Open Database Objects

thatjeffsmith SQL Developer 45 Comments

In yesterday’s post I talked about you could use SQL Developer’s Describe (SHIFT+F4) to open a PL/SQL Package at your cursor. If you actually try to describe the package as you see it in the above screenshot, you’ll get an error: I neglected to say in yesterday’s post that I was highlighting the package name before I hit SHIFT+F4. This …