Friday, September 26, 2008

pass a parameter to a cursor -oracle

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;

No comments:

Post a Comment

Thanks to given comments.......

My Blog List