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
Showing Line Numbers
Right-click in the gutter, turn it on. It’ll remember this going forward. You’ll need to do it for the SQL Worksheet and Code (PLSQL) Editor.
It’s also a preference, if you forget to right-click.
Setting Defaults for Exports
Always setting your grid exports to ‘Inserts’ and to the Clipboard? Tired of clicking? You can fix that.
Run your query, or browse your table/view – right click, Export.