Skip to Main Content
Forums

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!

Executing single blocks of code where mulitple blocks exist

968686Oct 16 2012 — edited Oct 16 2012
When I enter just SQL statements as single blocks of code, and then Run Statement (Ctrl + Enter), only the statement where the caret is executes. So, enter 6 SQL statements (semi-colons at the end of each) and place the caret on any one of them and Run Statement. Just that statement is processed.

When the code blocks include any PL/SQL with SQL, when I Run Statement the entire page of code executes - whether executing PL/SQL or SQL blocks

I am entering this on a SQL page, but even so, the PL/SQL executes on its own on a SQL page. So I'm thinking that the Run Statement should still run only the statement where the caret is.

I've just started using SQL Developer again and I'm sure my older version allowed this. So could this be a setup issue in the version I am now using (3.2.10.09) ?

Any ideas/suggestions?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2012
Added on Oct 16 2012
#sql-developer
2 comments
113 views