Forums Active Threads
Print Thread
FORMATTER Indents after BEGIN END block
#62640 07/09/21 09:55 PM
Joined: Apr 2001
Posts: 86
Tampa, FL, USA
F
Felix Offline OP
Member
OP Offline
Felix
Member
F
Joined: Apr 2001
Posts: 86
Tampa, FL, USA
In a SQL Window the PL-SQL formatter indents the next SELECT statement. In the following example the 1st SELECT with get indented.

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

SELECT 1 FROM dual;

SELECT 1 FROM dual;

Fair Bits...
Felix A. Hernandez
Re: FORMATTER Indents after BEGIN END block
Felix #62641 07/10/21 07:46 AM
Joined: Aug 1999
Posts: 22,212
Marco Kalter Offline
Member
Offline
Marco Kalter
Member
Joined: Aug 1999
Posts: 22,212
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.

Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Privacy Policy · Forum Rules · Mark All Read Contact Us · Forum Help ·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.050s Queries: 14 (0.015s) Memory: 2.4969 MB (Peak: 3.0395 MB) Data Comp: Off Server Time: 2024-05-09 00:20:09 UTC
Valid HTML 5 and Valid CSS