Tag Archives: ORA-01427

ORA-01427: single-row subquery returns more than one row

oracle

ORA-01427: single-row subquery returns more than one row
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.
Action: Use ANY, ALL, IN, or NOT IN to specify which values to compare or reword the query so only one row is retrieved.

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/