Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

ApexBineJan 19 2016 — edited Jan 19 2016

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

This post has been answered by thatJeffSmith-Oracle on Jan 19 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2016
Added on Jan 19 2016
3 comments
1,234 views