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, 2221🔥, 0💬
Popular Posts:
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...