Declaring a Cursor v13

In order to use a cursor, it must first be declared in the declaration section of the SPL program. A cursor declaration appears as follows:

CURSOR <name> IS <query>;

name is an identifier that will be used to reference the cursor and its result set later in the program. query is a SQL SELECT command that determines the result set retrievable by the cursor.

Note

An extension of this syntax allows the use of parameters. This is discussed in more detail in Parameterized Cursors.

The following are some examples of cursor declarations:

CREATE OR REPLACE PROCEDURE cursor_example
IS
    CURSOR emp_cur_1 IS SELECT * FROM emp;
    CURSOR emp_cur_2 IS SELECT empno, ename FROM emp;
    CURSOR emp_cur_3 IS SELECT empno, ename FROM emp WHERE deptno = 10
        ORDER BY empno;
BEGIN
    ...
END;