InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How To Open And Close An Explicit Cursor? |
|
Answer» An EXISTING cursor can be opened or CLOSED by the OPEN or CLOSE 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 OPEN c_list; OPEN t_list; CLOSE c_list; CLOSE t_list; END; /An existing cursor can be opened or closed by the OPEN or CLOSE statement as shown in the following sample script: |
|