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