What is the use of Parametric Cursor ?

Questions by jayshree13   answers by jayshree13

Showing Answers 1 - 0 of 0 Answers

Code
  1. DECLARE

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

  3.         v_deptNo employee.id%TYPE:=10;

  4.         v_countEmp NUMBER;

  5.     BEGIN

  6.         OPEN c_emp (v_deptNo);

  7.         FETCH c_emp INTO v_countEmp;

  8.         CLOSE c_emp;

  9.     END;

  10.  



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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions