Using Explicit Cursors  «Prev 

Building Cursor Block using PL/SQL

1) In the DECLARE section, PL/SQL variables and the cursor are defined.
1) In the DECLARE section, PL/SQL variables and the cursor are defined.

2) OPEN signals the opening of the cursor.
2) OPEN signals the opening of the cursor.

3) FETCH signals the retrieval of records into the cursor variable.
3) FETCH signals the retrieval of records into the cursor variable.

4) CLOSE signals the closing of the cursor after the processing of data is complete.
4) CLOSE signals the closing of the cursor after the processing of data is complete.