Beautifier Select Alias Alignment Fails When Using Static Text or Formulas

Nathan

Member
If I run beautifier on this, I get expected results:

SQL:
SELECT 1   AS Column1
      ,20  AS Column2
      ,300 AS Column3
FROM   dual;

But as soon as I add any static text in the select list, it fails to align the alias columns like so:

SQL:
SELECT 1 AS Column1
      ,20 AS Column2
      ,300 AS Column3
      ,'This breaks beautifier alias alignment' AS Column4
FROM   dual;
 
Last edited:
For compound expressions and long string literals this will indeed not align. This is on the list of enhancement requests.
 
Back
Top