How to Open your PL/SQL Objects…With the Keyboard in SQL Developer

thatjeffsmith SQL Developer 8 Comments

Tell Others About This Story:

I have some code…

BEGIN
 give_raises();
END;
/

I can guess that GIVE_RAISES is a procedure of some kind. But now I want to open it, or ‘go to it’ or ‘step into it.’

And I want to do so without having to pick up my mouse.

So I could tell you about the Ctrl+Click trick, but that’s all mouse.

So what’s a child of the 80’s to do?

Define a keyboard shortcut for ‘Open Declaration’ and then use that.

Ctrl+Mouse Click versus using the keyboard to open my procedure.

It’s not JUST for PL/SQL

Yup, it works for TABLES too!

Note that I have two Document Tab Groups going, that’s why you can see my SQL Worksheet and the EMPLOYEES table side-by-side.

Keyboard Shortcuts

We don’t have enough keys to assign EVERYTHING a keyboard shortcut. Open Declaration was one of them. So, decide what makes sense for you. For me, it was ALT+I (I = Inspect.)

Everything You Need to Know about Keyboard Shortcuts PLUS A Cheat Sheet!

Related Posts

Tell Others About This Story:

Comments 8

    1. thatjeffsmith Post
      Author

      The exact same way.

      So if I have

       
      BEGIN
       customer_data.get_customer(id=>i/*varchar2*/,name=>n/*varchar2*/,regno=>r/*varchar2*/,language=>l/*varchar2*/
       );
       END;
       /

      And i put my cursor on the get_customer text, when it opens the Package, the focus will be on the declaration for the get_customer procedure.

    2. Thank you very much.

      When I Ctrl+Click a function defined inside the same package it works perfectly but when I Ctrl+Click a function that is defined in another package, the focus ends in the package header and not in the package body.

    3. thatjeffsmith Post
      Author
  1. Hi. Thanks for the great SQL Developer Tool. The F5 shortcut(run script) in worksheet is OK and handy. But almost in every session I hit the F5 in the script output pane and the worksheet is emptied. Can your team fix these please.

    1. thatjeffsmith Post
      Author

      The script output is emptied or the editor itself is cleared?

      Neither should be happening, and I don’t see that happening. What version do you have? Can you post the exact series of steps you are doing to see that behavior?

Leave a Reply

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