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?


      The code below is compiled and executed in Oracle Database 18c (18.4), but the parser ( 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