ORA-01427 single-row subquery returns more than one row
What causes an ORA-01427 error?
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 Xynomix can help
Use ANY, ALL, IN, or NOT IN to specify which values to compare or reword the query so only one row is retrieved.
Contact us for more information. To learn more about ways we can support your database visit our Oracle database consultancy page.
On submitting this form, Xynomix will store your details and may contact you in relation to your request. For more information on how we process data, please see our privacy notice.