ThatJeffSmith

SQLDev Trick: SHIFT+Hover to Peek Into a Stored Proc

I’m poking around an unfamiliar schema or environment. I’m not sure what these procedures do. I could open them, but I’m lazy and I don’t want the tool to open another document/window.

The ‘mystery’ code:

Some PLSQL code that does...

These programs are self-documenting as they have the most awesome names ever! I’m guessing that one package will blast my enemies?, but I’m not sure. If only I could peek into the source without opening it!!!

Hmm, what’s this thing do?

The first mouse

If I hold down shift and then mouse-hover over an object in the tree, in this case some PL/SQL SYS packages, SQL Developer will peek into the object and popup the source code under your mouse.

Since I couldn’t figure out how to capture this in a screenshot, I went and did the next best thing – recorded a 10 second video. No sound, so don’t worry about my voice putting you to sleep. — STRIKE THAT –

Thanks to the awesome folks at @TechSmith, I figured out how to setup a screenshot timer delay in SnagIt!

Here’s the picture (and I’ll leave the video of course.)

Hold down 'SHIFT', then mouse over on a tree item

If you can’t see the movie frame above try clicking here to watch the movie.