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

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




      I'm using SQLDev Version


      I have a SQL Statement which contains

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


      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,