Use cursor to do full table scan : Cursor Value « Cursor « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Cursor
  3. Cursor Value

Use cursor to do full table scan

    
SQL> CREATE TABLE emp (
  2    id         NUMBER PRIMARY KEY,
  3    fname VARCHAR2(50),
  4    lname  VARCHAR2(50)
  5  );

Table created.

SQL>
SQL> INSERT INTO emp (id, fname, lname)VALUES (1, 'A', 'B');

1 row created.

SQL> INSERT INTO emp (id, fname, lname)VALUES (2, 'C', 'D');

1 row created.

SQL> INSERT INTO emp (id, fname, lname)VALUES (3, 'Enn', 'F');

1 row created.

SQL> INSERT INTO emp (id, fname, lname)VALUES (4, 'G', 'H');

1 row created.

SQL> INSERT INTO emp (id, fname, lname)VALUES (5, 'G', 'Z');

1 row created.

SQL>
SQL>
SQL>
SQL> SET SERVEROUTPUT ON ESCAPE OFF
SQL>
SQL> DECLARE
  2     CURSOR auth_cur IS SELECT * FROM emp;
  3  BEGIN
  4
  5     FOR v_emp IN auth_cur
  6     LOOP
  7        DBMS_OUTPUT.PUT_LINE(v_emp.lname);
  8     END LOOP;
  9
 10  END;
 11  /
B
D
F
H
Z

PL/SQL procedure successfully completed.

SQL>
SQL> drop table emp;

Table dropped.








Related examples in the same category

1.Cursor with a single value
2.Update statement with cursor variable
3.Server-side cursor variables.
4.A cursor FOR loop.
5.Cursor Variable Example 2
6.Read full table data from a cursor
7.Single column cursor
8.Use Complex cursor to simplify the pl/sql logic
9.Use data referenced by cursor to update table
10.Use number functions when creating a cursor value
11.Form sentences from database data
12.Two identical queries to demonstrate the impact of changes