Declaring a Cursor v11
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;