Can you pass a parameter to a cursor ?
ORACLE Interview Questions and Answers (Part 5)
(Continued from previous question...)
42.Can you pass a parameter to a cursor ?
Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear. CURSOR c1 (median IN NUMBER) IS SELECT job, ename FROM emp WHERE sal > median;
(Continued on next question...)
Other Interview Questions