FORMATTER Indents after BEGIN END block

[Felix]

In a SQL Window the PL-SQL formatter indents the next SELECT statement. In the following example the 1st SELECT with get indented.

DECLARE
  r INTEGER;
BEGIN
  r := 1;
END;
/

SELECT 1 FROM dual;

SELECT 1 FROM dual;

 

[Marco Kalter]

The PL/SQL Beautifier does not support scripts with multiple statements. It can only process single DML statements or PL/SQL Blocks. You would need to mark a statement or PL/SQL Block before invoking the beautifier.