Search notes:
ORA-01787: only one clause allowed per query block
select count(*) from
user_objects
group by
object_type
group by
status;
See also
Other Oracle error messages
Index