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