Return
-
Title
Multi-query in Query Builder gives "Toad for Data Analyst: ORA-01427: single-row subquery returns -
Description
When I run a multi-query that I created in the Query Builder I get the following error in the message column of the Results pane.
"Toad for Data Analyst: ORA-01427: single-row subquery returns more than one row."
For example running the following generated by the Query Builder will result in ORA-01427
SELECT d.location_ID
FROM departments d
WHERE d.department_ID = (SELECT e.department_id
FROM employees e
WHERE e.manager_ID = 100)
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.