3 Replies Latest reply on Jan 19, 2016 3:38 PM by thatJeffSmith-Oracle

    Query Builder: Error message 'Unexpected token "over"'

    ApexBine

      Hello,

       

      I'm using SQLDev Version 4.1.3.20.

       

      I have a SQL Statement which contains

      count( * ) over (partition by ...)

      and

      listagg(col1, ', ') within group (order by ...) over (partition by ...)

       

      It works well in my Worksheet, but when I switch to the Query Builder, I receive the following message:

      Text contains unsupported syntax.

      Parsing error:

      Failed to parse SQL query.

      Invalid SELECT statement.

      Unexpected token "over" at line 19, pos 25.

      Query Builder disabled.

       

      Is it a bug or a just feature that's not been implemented yet?

       

      Best regards,

      Sabine