Error "ORA-01427: Single-row subquery returns more than one row" when executing a query (4304997)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error "ORA-01427: Single-row subquery returns more than one row" when executing a query
Description

The following error occurs when executing a query:
"ORA-01427: Single-row subquery returns more than one row"
Cause

Not a Toad issue. A Subquery in the sql statement is returning multiple rows, when one is expected
Resolution

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. If only one row is expected to be returned, then the table data needs to be reviewed.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title