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.
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.
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.