Explain How To Create A Dynamic Cursor With The Dynamic Option?

1.	Explain How To Create A Dynamic Cursor With The Dynamic Option?
Answer» When a cursor is declared as DYNAMIC, the cursor reflects all CHANGES made to the base tables as the cursor is scrolled around. Declare cursor_name cursor [ STATIC \| KEYSET \| DYNAMIC \| FAST_FORWARD ] FOR select_statement The dynamic option does not SUPPORT ABSOLUTE FETCH. When a cursor is declared as DYNAMIC, the cursor reflects all changes made to the base tables as the cursor is scrolled around. The dynamic option does not support ABSOLUTE FETCH.

Answer»

When a cursor is declared as DYNAMIC, the cursor reflects all CHANGES made to the base tables as the cursor is scrolled around.

Declare cursor_name cursor [ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ] FOR select_statement

The dynamic option does not SUPPORT ABSOLUTE FETCH.

When a cursor is declared as DYNAMIC, the cursor reflects all changes made to the base tables as the cursor is scrolled around.

The dynamic option does not support ABSOLUTE FETCH.

Discussion