Cursors provide a flexible way to retrieve and operate data from tables. cursors are mainly used on servers to process SQL statements sent from clients to servers, or data processing requests in batch processing, stored procedures, and triggers.
How can I use a cursor?
First declare the cursor:
Declare cursor_name cursor [local | global] [forward_only | scroll] [static | keyset] [dynamic | fast_forward]... for select_statement [for update [of column_name [,... n]
Then open the cursor:
Open {global] cursor_name} | cursor_variable_name}
Read data from the cursor:
Fetch [[next | prior | first | last | absolute {n | @ nvar} | relative {n @ nvar}] from] {global] cursor_name} | @ cursor_variable_name} [@ variable_name [,... n]
Close and release the cursor. They are:
Close {[global] cursor_name} | cursor_variable_name}
Deallocate {[global] cursor_name} | @ cursor_variable_name}