Cursor | Oracle DBA Tutorial pdf

Cursor

Declaring cursor
CURSOR cursor_name IS SELECT statement;
Processing cursor
OPEN cursor_name;
FETCH cursor_name INTO variable(s);
CLOSE cursor_name;
Cursor attributes
%FOUND, %NOTFOUND, %ISOPEN, %ROWCOUNT
Cursor FOR loop
FOR variable IN cursor_name LOOP
Statement(s);
END LOOP;