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 …
Getting Your DBMS_OUTPUT Super Fast
SQL Developer has a DBMS Output panel you can open and add to your desktop. You then add a connection you want to poll, and then you enable polling. It’s about 4 clicks. If you want to increase the default buffer size from 20,000 characters, then that’s a few more clicks and keystrokes. A friend of the blog (Thanks Koen!)… …
Adding Common Columns to Tables via Templates and Transformation Scripts
In Oracle SQL Developer Data Modeler, you can create a table in your relational design that stores columns that you want to be added to all of your other tables. Call it, ‘table_template.’ Now call the transformation script. Tools > Design Rules & Transformations > Transformations. Before After These are cool, but they don’t belong in my Logical model! So …
SQL Editor Code Templates: A Must-Know Trick
Oracle Docs just underwent a facelift, and I was testing to make sure that the code insight feature in SQL Developer was still able to pick out our code samples. Good news, it still works! But, I was getting distracted by a bit of code that LOOKED like it was DOCS related, yet wasn’t… So if it’s not coming from …
Oracle SQL Developer: Code on Demand
I’ve recently spent a few hours debugging some user defined reports. A post on how to add trace/disconnect context menus to a session report required that I figure out what session my worksheet was running under. The code was easy… SELECT SYS_CONTEXT (’USERENV’, ‘SID’) FROM DUAL; …but I’m lazy. So this: The Setup Open your preferences and go to the …