top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: Is it possible to pass a parameter to a cursor?

+2 votes
108 views
Oracle: Is it possible to pass a parameter to a cursor?
posted Dec 24, 2014 by Archana

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

Explicit cursors can take parameters, as the example below shows. A cursor parameter can appear in a query wherever a constant can appear.
Example:
CURSOR c1 (median IN NUMBER) IS
SELECT job, ename FROM emp WHERE sal > median;

answer Dec 29, 2014 by Arun Gowda
...