Running worksheet queries without highlighting them (?)

CTRL-A will highlight all text in worksheet, then hit "Run".

If you want to run multiple queries at the same time then you will obviously want to tick the " [ ] show query results in new tabs" box under

Tools -> Preferences -> Database -> Worksheet,

otherwise only the last queries results will be visible in the single query results tab.

Hitting "Run Script" does execute everything in the worksheet without you having to move the cursor or highlight anything.

AnnieM wrote:

 

Greetings,

 

I am using Version 4.2.0.17.089 of SQL Developer.

Oracle version is: 10.1.0.5.0

 

Why do I need to select/highlight the queries I want to run in SQL Developer?

 

Is there a way to configure so pressing 'Run" would execute all queries on the SQL worksheet?

 

For instance if I select "run" with this on the screen, nothing happens:

 

I need to select all lines, e.g.:

 

I googled for a solution but could not find. Perhaps I am wording it incorrectly.

 

 

Thank you so much for your help!

Annie

The first two icons in tye worksheet toolbar are 'Run Statement (Control-Enter)' and 'Run Script (F5)'

If you want to run a single statement, just place your cursor in that statement (don't actually select any of it) and hit the appropriate icon or key sequence.

If you want to run all of the statements in the worksheet, just hit the appropriate icon or key.