SQL Beautifier indentation

[michaeltf]

It's a great feature to manage codes worry-free. May I ask is there options to indent codes according to user's definitions? I am using v11 here.

My case is as following, it is about the htp table related functions:

HTP.TABLEOPEN; --First level
___HTP.TABLEROWOPEN; --Second level
______HTP.TABLEDATA(...); --Third level
___HTP.TABLEROWCLOSE; --Second level
HTP.TABLECLOSE; --First level

It's like pressing tab is spending much time... but I would like to know is there a way to beautify it?

 

[Marco Kalter]

No, this is currently not possible. You can only format this manually and add a NoFormat directive to prevent the PL/SQL Beautifier from re-aligning the code later:

-- NoFormat Start
HTP.TABLEOPEN; --First level
   HTP.TABLEROWOPEN; --Second level
      HTP.TABLEDATA(...); --Third level
   HTP.TABLEROWCLOSE; --Second level
HTP.TABLECLOSE; --First level
-- NoFormat End