Database Error Messages

ORA-01787

only one clause allowed per query block

Cause

An attempt was made to use more than one WHERE, GROUP BY, CONNECT BY, or HAVING clause in the query.


Action

Combine the duplicate clauses into a single clause and retry the statement.