Demo: AutoTrace – Generate Hints and Compare Different Execution Plans & Stats

thatjeffsmith SQL Developer 6 Comments

For some reason I procrastinated setting up my video software on my new work machine. Big mistake. I put together this animated GIF to show some new things in version 4.2: Updated formatter – better support for ANSI joins Opening objects referenced in your execution plans Inserting Hints Not new but underutilized: how to compare plans/AutoTraces One Last Thing… …don’t …

Just another GIF: Debugging PL/SQL

thatjeffsmith SQL Developer 0 Comments

Start a debug session…step over some code…look at a variable…run to a breakpoint…investigate the data in a PL/SQL table…step into another program…check out the callstack. Just another day in animated GIFs and showing you what SQL Developer is capable of. If you’re curious or want more info, hit the ‘debug’ link at the end of this for all of my …

Your Most Requested SQL Developer Demos

thatjeffsmith SQL Developer 4 Comments

The team just got back from another Oracle User Group Conference, or I should say THE conference. I know most of you don’t get to go to conferences. Or have nice computers. Or use foreign keys. Or have nice things. BUT. One thing you do get to have today, is the same popular Oracle SQL Developer features demonstrated to you, …

Updated SQLcl: nicer inline editing and column completion

thatjeffsmith SQL Developer 22 Comments

We updated the Early Adopter offering of SQLcl today. Go get it. But first, I’m assuming you’ve heard of SQLcl? If not – Read the slidedeck, watch the movie. We’ve put in a ton of enhancements and even more bug fixes. And Kris showed off a new feature today that mimic’s our SQL Developer grid preference for displaying NULL ‘values’… …