Collections:
Retrieve Data from an Explicit Cursor in Oracle
How To Retrieve Data from an Explicit Cursor in Oracle?
✍: FYIcenter.com
If you have a cursor opened ready to use, you can use the FETCH ... INTO statement to retrieve data from the cursor into variables. FETCH statement will:
Here is a sample script showing you how to use FETCH statement:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR t_list IS SELECT first_name, last_name FROM employees; f_name VARCHAR2(10); l_name VARCHAR2(10); BEGIN OPEN t_list; FETCH t_list INTO f_name, l_name; DBMS_OUTPUT.PUT_LINE('Name = ' || f_name || ' ' || l_name); FETCH t_list INTO f_name, l_name; DBMS_OUTPUT.PUT_LINE('Name = ' || f_name || ' ' || l_name); -- FETCH t_list INTO l_name; -- must have two variables CLOSE t_list; END; / Name = Ellen Abel Name = Sundar Ande
⇒ Retrieve Data from a Cursor to a RECORD in Oracle
⇐ Open and Close an Explicit Cursor in Oracle
2018-07-22, 1982🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To View Data Files in the Current Database in Oracle? If you want to get a list of all tablespac...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...