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

thatjeffsmith SQL Developer 5 Comments

Tell Others About This Story:

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.

Tell Others About This Story:

Comments 5

    1. JeffS Post

      Just taking a guess here as I’m not a developer (thank goodness!) but this is probably something we get for ‘free’ from the JDeveloper framework and this is probably a feature that’s tied to that tree object.

  1. Nice tip! I like the video too. If you want to capture a screenshot like that, try “screenshot captor”. It has a time delay setting so you could set it for 2000 ms, take screenshot, the hover and wait. It’s got a ton of other useful options too.

    1. JeffS Post

Leave a Reply

Your email address will not be published. Required fields are marked *