open

SQL/PL

Open a cursor

Syntax

open_stmt:
          OPEN cursor_name

Description

The OPEN statement is used to open a cursor for subsequent fetching.

Example

declare gr_than_avg cursor for select * from acctmgr;    ...    open gr_than_avg;    get_next1: loop       fetch gr_than_avg into l_id, l_name, l_date, l_comm;       if not found then           leave get_next1;       end if;       if l_date >= lo_date and l_date <= hi_date then            set comm_sum = comm_sum + l_comm;           set comm_count = comm_count + 1;       end if;    end loop get_next1;    close gr_than_avg;