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, 1516🔥, 0💬
Popular Posts:
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
How To Convert a Unicode Strings to Non-Unicode Strings in SQL Server Transact-SQL? Since Unicode ch...
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...