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!

thatjeffsmith
Author

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

2 Comments

  1. Robert Moser Reply

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

Write A Comment