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, 1491🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...