Toad World® Forums

12.12.0.29 - Editor anonymous block with CTRL ENTER

I was trying to run this block

begin
insert into table values (null, null);
insert into table values (null, null);
insert into table values (null, null);
insert into table values (null, null);
insert into table values (null, null);
end;

In older version of toad, whole block was executed, with current beta only insert where cursor is located gets executed

Somehow I missed this message, but this behavior did change for Ctrl+Enter within PL/SQL in or around Toad 11.6. Ctrl+Enter in PL/SQL will isolate the SQL at caret including stripping PL/SQL specific syntax from it like INTO clause and the like.

Michael