FORWARD_ONLY CURSOR

This is the most unused logical area because it supports only NEXT operation.

Example: DECLARE FC CURSOR FORWARD_ONLY FOR SELECT * FROM DEPT

OPEN FC

FETCH FIRST FROM FC

Error Message

FETCH NEXT FROM FC

15 SALES LONDON

CLOSE SC

DEALLOCATE FC
Share/Bookmark

No comments: