DYNAMIC CURSOR

This is the logical area in which dynamic updations possible. We need to close and reopen the cursor for the modified values.

Example: DECLARE DC CURSOR DYNAMIC FOR SELECT * FROM DEPT

OPEN SC

FETCH FIRST FROM DC

15 SALES LONDON

UPDATE DEPT SET DEPTNO=10 WHERE DEPTNO=15

FETCH FIRST FROM DC

10 SALES LONDON

Note: ABSOLUTE N will not be supported by the dynamic cursor because dynamic updations are possible.

DYNAMIC CURSOR