harry

Cursors: LIKE ARRAY IN PHP

we can fetch the multiple variable value in cursor instead of scalar variable

Algorithm of cursor in pl/sql as described below

DECLARE for Cursors
Cursor OPEN Statement
Cursor FETCH Statement
Cursor CLOSE Statement
1. we have to declare the cursor DECLARE cur1 CURSOR FOR SELECT column name....
2. we have to OPEN CURSROR;
3. WE HAVE TO FETCH THE CURSOR.
4. WE HAVE TO CLOST THE CURSOR.