Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01787 – only one clause allowed per query block

Oracle Database Error Code ORA-1787 Description :

only one clause allowed per query block

Error Cause:

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

How to Solve :

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