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.

No comments:
Post a Comment