Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

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.