Fetch cursor to two variables

  
SQL>
SQL>
SQL> CREATE TABLE lecturer (
  2    id               NUMBER(5) PRIMARY KEY,
  3    first_name       VARCHAR2(20),
  4    last_name        VARCHAR2(20),
  5    major            VARCHAR2(30),
  6    current_credits  NUMBER(3)
  7    );

Table created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10001, 'Scott', 'Lawson','Computer Science', 11);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major, current_credits)
  2                VALUES (10002, 'Mar', 'Wells','History', 4);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10003, 'Jone', 'Bliss','Computer Science', 8);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10004, 'Man', 'Kyte','Economics', 8);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10005, 'Pat', 'Poll','History', 4);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10006, 'Tim', 'Viper','History', 4);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10007, 'Barbara', 'Blues','Economics', 7);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10008, 'David', 'Large','Music', 4);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10009, 'Chris', 'Elegant','Nutrition', 8);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10010, 'Rose', 'Bond','Music', 7);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10011, 'Rita', 'Johnson','Nutrition', 8);

1 row created.

SQL>
SQL> INSERT INTO lecturer (id, first_name, last_name, major,current_credits)
  2                VALUES (10012, 'Sharon', 'Clear','Computer Science', 3);

1 row created.

SQL>
SQL>
SQL> DECLARE
  2    firstName VARCHAR2(20);
  3    v_LastName  VARCHAR2(20);
  4    CURSOR c_lecturer IS
  5      SELECT first_name, last_name FROM lecturer;
  6  BEGIN
  7    OPEN c_lecturer;
  8    LOOP
  9      FETCH c_lecturer INTO firstName, v_LastName;
 10      EXIT WHEN c_lecturer%NOTFOUND;
 11    END LOOP;
 12    CLOSE c_lecturer;
 13  END;
 14  /

PL/SQL procedure successfully completed.

SQL>
SQL> drop table lecturer;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Below is a function that demonstrates how to use the FETCH statement
2.	Fetch value from cursor
3.	Fetches the records from a cursor variable that returns employee information
4.	legal and illegal FETCH statements.
5.	"ORA-1002: fetch out of sequence" because of the commit inside the SELECT..FOR UPDATE loop.
6.	A WHILE cursor fetch loop.
7.	Different BULK_COLLECT statements used for bulk binds
8.	Check Cursor%FOUND after fetching
9.	Fetch value in cursor until NOTFOUND
10.	ORA-01002: fetch out of sequence
11.	Fetch out cursor value and insert to another table
12.	PLS-00394: wrong number of values in the INTO list of a FETCH statement
13.	FETCH cursor BULK COLLECT
14.	Fetch cursor data to number variable
15.	Fetch cursor till cursorVariable%notfound
16.	Fetch cursor to table collection of row type
17.	Fetch cursor value to three variables
18.	Fetch row by row
19.	Fetch single column cursor to varchar2 variable

Fetch cursor to two variables : Cursor Fetch « Cursor « Oracle PL / SQL

Related examples in the same category