InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Define An Explicit Cursor? |
|
Answer» An explicit CURSOR must be defined in the declaration part of a procedure or function with the CURSOR ... IS STATEMENT as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE employee_id = 100; BEGIN NULL; END; /An explicit cursor must be defined in the declaration part of a procedure or function with the CURSOR ... IS statement as shown in the following sample script: |
|