SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer CLT + ENTER shortcut executes all the queries in worksheet instead of running the stat

Sudhanshu_Mar 13 2017 — edited Mar 21 2017

When I write SQL statement and run it with CNTL + ENTER it runs the entire worksheet instead of just the SQL statement I want to run. I end the SQL statement with semi colon and previous SQL statements are terminated with semi colons as well but on CLTL + ENTER shhortcut whole worksheet's SQL and PL/SQL gets executed ! I have searched the net and it has been reported by someone on stackOveflow too: Oracle SQL Developer - Ctrl+Enter runs whole worksheet instead of current line - Stack Overflow

I am using SQL Developer 4.0.0.13 and have Oracle Database 11gRel 2(11.2.0.4.0)

I checked the preferences and short cut settings and it seems to be set to the defaults.

When I highlight the SQL statement and run it with CLTL+ENTER shortcut it runs fine and executes only that query. How can i fix it.

Thanks.

This post has been answered by Sudhanshu_ on Mar 18 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 18 2017

Added on Mar 13 2017

#sql-developer

8 comments

7,317 views