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 …

Learning Oracle SQL Developer: The Video Hits

thatjeffsmith SQL Developer 2 Comments

I’ve got short videos for you, 2-10 minutes. I’ve got 20 minute videos. And I’ve got monster, hour long videos. 24 in total, covering everything from how to use the PL/SQL debugger, to building REST Services, to just writing better SELECT * queries. Send me your requests, always happy to build more. I just wish I had a voice made …

PL/Scope in Oracle Database 12c Release 2 and Oracle SQL Developer

thatjeffsmith SQL Developer 7 Comments

PL/Scope is one of my favorite features. It answers SO many questions. Where am I declaring this, where am I calling that, when am I referencing something? And, I can get this information automatically, without hitting the big, fat SOURCE data dictionary views. I’ve talked about this previously… …BUT, PL/SCope didn’t help me with tracking the SQL I used in …