Open Statement
This statement opens a cursor in the database, evaluates the specified statement, and associates the select statement's result table with the cursor.
It has the following syntax:
open cursor_variable for select_statement
[for update_clause];
update_clause is one of the following:
readonly [deferred | direct] update of column {, column}