InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Can You Pass A Parameter To A Cursor ? |
|
Answer» 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; 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; |
|