toad ctrl+enter equavalent in pl/sql developer

[bond636]

Hi,

What is the short cut for executing sql statements in pl/sql developer individually. Toad has Ctrl+enter and it executes that particular sql statement only. I am not able to do the same here.

For ex:

In my sql editor window, I have 2 queries and i want to execute one after another like shown below

select * from all_tables-----first execute this

select * from dba_tables-----next this one...

How can i do that in pl/sql developer. PLease let me know.

Thanks,

 

[mike]

If you put a ";" at the end of the sql statements, and select the "AutoSelect statement" in the SQL preferences, it will only execute the SQL that the cursor is on.

 

[patch]

If you install the Execute current statement plug-in from my site (http://bar-solutions.com) you can even add a shortcut key (CTRL-Enter) to this action.

 

[Bernhard S]

The standard Execute keyboard-shortcut is F8.
Via menu that's Session / Execute.
Just use that with the "AutoSelect statement" as explained by mike.

In Tools / Preferences you can even change the keyboard-shortcut to a different key, even CTRL-Enter.