Hi there!

In SQL DEveloper If you write several queries in a worksheet and separate then with semicolons you can execute different queries one at the time just pointing the cursor at them (not selecting SQL statement).
Is there any way to execute exactly on query in SQL Window (if there are multiple) without selecting the query text?

Thanks!

This is indeed possible. There are 2 options:

1. Press Ctrl-F8 when the cursor is on the statement. Now only the current statement is executed. You can assign a different key through the preferences (Tools > Preferences > Key Configuration > "SQL Window: Execute current statement").
2. Enable the "AutoSelect statement" preference (Tools > Preferences > SQL Window). Now the standard execute function will automatically select the current statement under the cursor and execute it. To execute multiple statements you now have to explicitly select them first in the editor, or use Ctrl-F8.

Thank you. This will really help me.