Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
What Happens If the UPDATE Subquery Returns Multiple Rows
What Happens If the UPDATE Subquery Returns Multiple Rows? - Oracle DBA FAQ - Understanding SQL DML Statements
✍: FYIcenter.com
If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, Oracle server will give you an error message. To test this out, you can try the following tutorial exercise:
UPDATE fyi_links SET (notes, created) = (SELECT last_name, hire_date FROM employees WHERE employee_id < id) WHERE id < 110; ERROR at line 1: ORA-01427: single-row subquery returns more than one row
The problem is the criteria in the subquery: "employee_id < id"
2007-04-21, 6294👍, 0💬
Popular Posts:
Enable ASP.NET polling using “web.config” file Now that all our database side is configured in order...
How To Change the Password of Another User Account? - MySQL FAQs - Managing User Accounts and Access...
What Information Is Needed to Connect SQL*Plus an Oracle Server? - Oracle DBA FAQ - Introduction to ...
What is application domain? Explain. An application domain is the CLR equivalent of an operation sys...
What is SMC approach of estimation?