Enhancement req.: execute current statement

[walterheck]

I like the new option in PL/SQL dev 7 to execute multiple queries very much.
What would be even better however, is if there was some way you could execute only the statement that the cursor is currently on. Ideally i would create two keyboard shortcuts: execute all statements and execute current statement.

I have for instance a few files that each contain several queries to check and several queries to correct certain situations. Each file covers one area of our product. Right now if i execute all queries in a file (this include correctional queries!), i am not a happy camper as you can understand

Could you make my (already very easy) life even easier?

 

[Marco van der Linden]

This is already possible. Go to 'Preferences/Window Types/SQL Window' and check 'Autoselect statement'.

Note however, that if you do this, you'll have to explicitly select statements if you want to execute multiple statements.

 

[walterheck]

So it's currently not possible to have it as I described? For instance use CTRL+F8 for executing all statements, and F8 for executing the current statement? Than that becomes my feature request

 

[mike]

It is possible, but in a roundabout way. Until they make the change, you can do this.

1. Make a simple macro to select everything and execute it.
(The macro consists of:
* CTL+A or whatever you have to edit/select all.
* F8 or whatever you have to execute it.)
2. Assign the macro to the menu in the macro library.
3. Assign the Macro menu item to Shift+F8 in the Preferences/Key Configuration.

For this to work, you will have to have the autoselect statement preference set also.

Mike

 

[walterheck]

Thanks for this solution!
(I still want to file it as a feature req. )