2 Replies Latest reply on Mar 6, 2019 10:09 AM by user2885917

    Parser can not parse the correct code:{ LATERAL (SELECT ... )(+) } Problem with parsing?

    user2885917

      The code below is compiled and executed in Oracle Database 18c (18.4), but the parser (18.4.0.376) cannot parse it.

      Is this some kind of problem with parsing?

       

      select d1.dummy c1,

             sq.dummy c2

        from dual    d1,

             lateral (select dummy

                        from dual d2

                       where d1.dummy < d2.dummy

                          or d1.dummy > d2.dummy)(+) sq

      parser_syntax_error_2019_03.png