Advice: Let user easily execute sql he wants in SQL Window.

[oracle developer]

I now test a oracle client,name Golden32.

And It can let user use "ctrl - enter" key to execute the current SQL at the cursor.

But In PL/SQL Developer , I must to select the whole text of SQL,and press F8 to execute it.

Although It give me hand to execute multiple SQLs or only execute pointed text in one SQL.

So, I advise PL/SQL Developer should add function to use CTRL-ENTER run the only one SQL under the cursor.It is very useful for execute a sql with many text and user doesn't need to scroll and select the text of the SQL.

THX.

 

[sukhadukkham]

you can go to tools=>preferences=>sql window and check "autoselect statement".

 

[oracle developer]

Originally posted by sukhadukkham:
you can go to tools=>preferences=>sql window and check "autoselect statement".

Yes, I have checked "autoselect statement",but I don't know how to let pl/sql dev autoselect for me.

for example,I type such simple codes in sql win:

select sysdate from dual;

select 333 from dual;

And, I want to get such function:
while I place cursor into any position of second statement, I can directly use a shortkey to run this sql.
And If I place cursor into any position of first statement,I also can directly use a shortkey to urn it.

But now,I must select each sql and press F8 to execute it.

 

[harrydebruin]

The suggestion from sukhadukkham works fine. Just tested it. Just place the cursor within the sql and press F8 to execute. Sql will be hilighted and executed.

Cheers,
Harry

 

[oracle developer]

Thx, I know how to use function "autoselect statement" and "autoexecute statement".

And,if I can change the shortkey from F8 to ctrl-enter,it will be more well.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[ScottMattes]

Oracle Developer:
for the time being you could use AutoHotKey to make ctl-enter do an F8 if you are in PL/SQL Dev (autohotkey.com).

Marco:
i think that this has been asked for before, but while you are at it, how about making the key setting window sortable (both columns). AND adding all keys for all windows to the list (command, all of SQL, etc).

Thank you!