System Reference Summary : Statements : OpenROAD SQL Statements : Open Statement
 
Share this page          
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}