Please send your Questions & Answers or Feedback to "mohan@javabook.org"

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;
Related Posts Plugin for WordPress, Blogger...
Flag Counter