This discussion is archived
2 Replies Latest reply: Oct 16, 2012 8:55 AM by jeffb1 RSS

Executing single blocks of code where mulitple blocks exist

968686 Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points