Cursor

states of cursor
1.declare cursor_emp cursor
for
select eid, ename from emp

2.open cursor_emp

3.fetch cursor_emp

4.close cursor_emp

5.deallocate cursor_emp