Oracle Error Codes

All Oracle Database Error Codes

Oracle database error code ORA-01427 – single-row subquery returns more than one row

Oracle Database Error Code ORA-1427 Description :

single-row subquery returns more than one row

Error Cause:

The outer query must use one of the keywords ANY, ALL, IN, or NOT IN to specify values to compare because the subquery returned more than one row.

How to Solve :

Use ANY, ALL, IN, or NOT IN to specify which values to compare or reword the query so only one row is retrieved.