To use a cursor, it must first be declared in the declaration topic 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 statement that determines the result set retrievable by the cursor.
The following codes 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;