Oracle - Retrieve Data from a Cursor to a RECORD in Oracle

Retrieve Data from a Cursor to a RECORD in Oracle

Q

How To Retrieve Data from a Cursor to a RECORD in Oracle?

✍: FYIcenter.com

A

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

⇒Working with Cursors in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2018-07-22, 557👍, 0💬

Retrieve Data from an Explicit Cursor in Oracle
How To Retrieve Data from an Explicit Cursor in Oracle? 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: Retrieve all the fields from the row pointed by the current cursor pointer and assign them... 2018-07-22, 572👍, 0💬

Retrieve Data from a Cursor to a RECORD in Oracle
How To Retrieve Data from a Cursor to a RECORD in Oracle? 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 ... 2018-07-22, 558👍, 0💬

Use FETCH Statement in a Loop in Oracle
How To Use FETCH Statement in a Loop in Oracle? If you have a cursor opened ready to use, you can also use the FETCH statement in a loop to retrieve data from the cursor more efficiently. But you need to remember to use an EXIT statement break the loop when the cursor pointer reaches the end. The sc... 2018-04-07, 540👍, 0💬

Open and Close an Explicit Cursor in Oracle
How To Open and Close an Explicit Cursor in Oracle? An existing cursor can be opened or closed by the OPEN or CLOSE statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE employee_id = 100; BEGIN OPEN c_list... 2018-07-22, 467👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.