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;

/