4 Replies Latest reply on Feb 7, 2020 4:54 PM by 4156062

    19.4 - Column aliases for function expressions not aligning with simple expressions

    4156062

      Thanks to your generous help, I only have a few small nitpicks remaining when it comes to the automatic formatting. Even large procedures work well by now, so thanks for being so responsive!

       

      I find it confusing that column aliases for function expressions and simple expressions do not line up. Once again, I am using SQL Developer 19.4.0.354 with Default Settings.

       

      SELECT
          table_name  AS col_alias,
          prod        AS col_alias2,
          CASE owner
              WHEN 'SYS'     THEN
                  'The owner is SYS'
              WHEN 'SYSTEM'  THEN
                  'The owner is SYSTEM'
              ELSE
                  'The owner is another value'
          END AS col_alias3
      FROM
          all_tables;
      

       

      Ideally, I would like not only col_alias and col_alias2 to line up, but col_alias3 as well.

       

      I have read https://community.oracle.com/message/15484312 and you mentioned that

       

           | :alignTabColAliases  & [id) column & [id) expr & [id^) select_term & [id+1) as_alias & [scope) select_clause

       

      should fix this particular issue, but that does not seem to be the case!? Or am I missing something?