I’ll show you 3 cool tips and tricks for working with PL/SQL in SQL Developer…in under 7 minutes!

  1. In-code navigation – click into where your objects are declared
  2. Test Query – see if your SQL is gonna work BEFORE you compile it
  3. Using the Code Outline

For those that can’t do video, basically you can

Ctrl-Mouse-Hover Navigate ANYWHERE

Not just on tables, but also on local variables.

Click on Y to go to where you declared Y

Right-Click to Test a Query

Open and Use the Code Outline

Need More Info? Watch the Video!


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. Robert Moser Reply

    I’m using version The topic “Test Query …” is gray and not usable. What can be the reason for this?

Write A Comment