dinesh.smhdr

 Profile Answers by dinesh.smhdr 

• Sep 13th, 2011

 

Code
DECLARE


        CURSOR c_emp (cin_No NUMBER) IS SELECT COUNT(*) FROM employee WHERE id = cin_No;


        v_deptNo employee.id%TYPE:=10;


        v_countEmp NUMBER;


    BEGIN


        OPEN c_emp (v_deptNo);


        FETCH c_emp INTO v_countEmp;


        CLOSE c_emp;


    END;


 

Consider the above example , we can pass the variable cin_No dynamically to the cursor.