CURSOR v_cur IS SELECT *

FROM emp;

CURSOR c (x NUMBER, y NUMBER)

IS SELECT x,y FROM abc;

CURSOR v_cur IS SELECT empno,

sal FROM emp FOR UPDATE;

CURSOR

v_cur (p_dept NUMBER) IS SELECT * FROM emp WHERE depno=p_dept;

v_cur (p_dept NUMBER) IS

CURSOR SELECT * FROM emp WHERE depno=p_dept;