SQLDeveloper: execute current line without highlighting
oracle-sqldeveloper
Solution
For those who also wonder about the same thing, here is what you gotta do. End each statement with `;` and it works.
select * from item
;
select * from product;
Problem
In Toad one can easily execute current line without highlighting it. Let say, you have a worksheet like this: ``` select * from item -- cursor here select * from product ``` When I click on `CTRL+Enter` I want only the line where the cursor is to be executed. In SQLDeveloper, if there is no second line, `CTRL+Enter` works as I want. Basically, I want to do the same as described here, but for some reason, I can't find the `Tools -> Preferences -> Window Types -> SQL Window and check "AutoSelect statement"` in the version of the SQLDeveloper I am using: `4.0.0.13`, build `Build MAIN: 13.80`. Seems like, this functionality is taken out in the `4.x` of Oracle SQLDeveloper?