3 Tips for Working with PL/SQL

thatjeffsmith SQL Developer 2 Comments

Tell Others About This Story:

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!

Related Posts

Tell Others About This Story:

Comments 2

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

    1. thatjeffsmith Post
      Author

Leave a Reply

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