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.


I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.


  1. Steven Brown Reply

    Hi Jeff, does this still work? I am on version and all I see when I shift-hover over a procedure is ‘Procedure schemaname.procedure_name’

  2. Alexander Kislyakov Reply

    Nice trick! But why it doesn’t work in Schema Browser?

    • JeffS

      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.

  3. 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.

    • JeffS

      If you like that, I’ve got a whole slew of tricks to check out 🙂 Thanks for hanging out and saying hi!

Write A Comment