HAVING clause without GROUP BY?
A colleague of mine sent me a query where he used a HAVING clause without a GROUP BY one, and the query works.
According to the SQL Reference manual, it should not:
Specify GROUP BY and HAVING after the where_clause and hierarchical_query_clause.
Tested on 18.104.22.168 and 22.214.171.124.
You can test with the following query:
FROM (select object_name, 1 dummy from user_objects)
HAVING dummy = 1;
Shouldn't there be a syntax error raised?