On Running Oracle Scripts with Relative Paths

thatjeffsmith SQL Developer 0 Comments

A customer ‘ambushed me’ – how dare they!?! – at the conference today, needing help getting their scripts to work. So something like this: And the way the customer wants to run scripta.sql (which calls scriptb.sql) So, where is SQL Developer going to look for scriptA? And when it gets to the @child\scriptb.sql? We can call scripts.sql using @c:\users\jdsmith\desktop\parent\scriptA.sql But, …

3 Quick SQL Developer Tips to Kick off 2018

thatjeffsmith SQL Developer 0 Comments

I’m in Denver today, to present one of my favorite talks, SQL Developer Tips & Tricks. Since I know most of you won’t be here today, I thought I’d share 3, super-quick tips. I get asked ‘how to do this’ type stuff, all the time. Copying Column Headers with your Data Ctrl+Shift+C   Showing Line Numbers Right-click in the gutter, …

Using Proxy Connections in Oracle SQL Developer

thatjeffsmith SQL Developer 4 Comments

A relatively new feature, Proxy User Authentication allows you to connect using someone else’s credentials. Or as Oracle-Base puts it: Since Oracle 9i Release 2 it has been possible to create proxy users, allowing you to access a schema via a different username/password combination. This is done by using the GRANT CONNECT THROUGH clause on the destination user. So I’m …

Scripts – on Spooling and Output to Screen in Oracle SQL Developer

thatjeffsmith SQL Developer 4 Comments

When executing scripts in SQL Developer, the amount of output we display on the screen is LIMITED. By design, we only show you 5,000 records from any query, and we limit the amount of output in total for a single script execution to 10,010 rows. This is controlled here: I know what you’re thinking… Why? A few reasons, but practicality …

Video: A Tour of the SQL Developer Desktop

thatjeffsmith SQL Developer 0 Comments

In this 10 minute video I’ll show you: how to open a panel how to move a panel how to reset your desktop if something gets ‘borked’ how to create new desktop tab groups (for docking things) AND how to ‘float’ your doc or panel to a secondary monitor Welcome 2018! Please be sure to subscribe to my YouTube channel …

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 …

Your Favorite Oracle SQL Developer Posts of 2017

thatjeffsmith SQL Developer 2 Comments

Yes, it’s that time of year again. Let’s take a quick look back at the posts (from 2017!) you read the most. SQL Developer v17.2 is now available SQL Developer v4.2 is now available Release News, What’s On Tap (where I announce our new numbering scheme) Real Time SQL Monitoring Update What is the Future of SQL Developer? Oracle Database …