Collections:
Error: Exact Fetch Returns More Rows in Oracle
Can You Assign Multiple Query Result Rows To a Variable in Oracle?
✍: FYIcenter.com
You can use "SELECT ... INTO variable" to assign query results to variables. But what happens if the SELECT statements return multiple rows? The answer is that you will get a run time error. The following tutorial exercise shows this error condition:
DECLARE fname VARCHAR2(10); lname VARCHAR2(10); BEGIN SELECT first_name, last_name INTO fname, lname FROM employees WHERE employee_id = 100; DBMS_OUTPUT.PUT_LINE('Name = ' || fname || ' ' || lname); SELECT first_name, last_name INTO fname, lname FROM employees WHERE employee_id > 100; DBMS_OUTPUT.PUT_LINE('Name = ' || fname || ' ' || lname); END; / ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 8 Name = Steven King
⇒ Invoke Built-in Functions in PL/SQL in Oracle
⇐ Assign Query Results to Variables in Oracle
2018-09-24, 2212🔥, 0💬
Popular Posts:
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...