Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.
Version 188.8.131.52 Build MAIN-19.59 of Oracle SQL Developer doesn't properly uderstand queries with "group by" clauses inside "with" block.
select owner, sum(bytes) bytes
group by owner;
u as (select owner, sum(bytes) bytes
group by owner)
select * from u;
While both queries are valid, in the second example it underlines query with yellow line and suggest wrong replacement: add sum(bytes) to group by clause.
Bugged, thank you.