Collections:
Retrieve Data from a Cursor to a RECORD in Oracle
How To Retrieve Data from a Cursor to a RECORD in Oracle?
✍: FYIcenter.com
If you have a cursor opened ready to use, you can also use the FETCH statement to retrieve data from the cursor into a RECORD variable as shown in the tutorial exercise below:
CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR t_list IS SELECT first_name, last_name FROM employees; TYPE name_rec IS RECORD ( f_name VARCHAR2(10), l_name VARCHAR2(10) ); n name_rec; BEGIN OPEN t_list; FETCH t_list INTO n; DBMS_OUTPUT.PUT_LINE('Name = ' || n.f_name || ' ' || n.l_name); FETCH t_list INTO n; DBMS_OUTPUT.PUT_LINE('Name = ' || n.f_name || ' ' || n.l_name); CLOSE t_list; END; / Name = Ellen Abel Name = Sundar Ande
⇒ Use FETCH Statement in a Loop in Oracle
⇐ Retrieve Data from an Explicit Cursor in Oracle
2018-07-22, 1624🔥, 0💬
Popular Posts:
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...