1 Reply Latest reply on Sep 26, 2016 5:08 PM by thatJeffSmith-Oracle

    [4.2EA] Formatter error

    Sentinel

      Thanks to Alex Nuijten over at his Notes on Oracle blog for this entertaining query that socks it to the query formatter:

       

      select listagg (b)
          within group (order by null) ||' Batman'
      from (select 0f/0 b
          from dual
       connect by level <= 14
        );
      

       

      Hitting Format (CTRL-F7) yeilds the following results:

       

      select listagg (b)
          within group (order by null) ||' Batman'
      from (select 0f
      /*** Syntax Error at line 2, column 16
      
      
      from (select 0f/0 b
                      ^^^  
      
      Expected: 
       ***//0 b
          from dual
       connect by level <= 14
        );