Oracle CLOSE operator.

Preamble

CLOSE operator – The final step in working with cursors is closing the cursor after you have finished using it.

Operator CLOSE syntax

CLOSE cursor name;

Options and arguments of the operator

• cursor name – The name of the cursor you want to close.

For example, you could close a cursor named c1 with the following command:

CLOSE c1;

Next is a function that shows you how to use the Oracle FETCH operator:

CREATE OR REPLACE Function FindCourse
( name_in IN varchar2 )
RETURN number
IS
cnumber number;

CURSOR c1
IS
SELECT course_number
FROM courses_tbl
WHERE course_name = name_in;

BEGIN

OPEN c1;
FETCH c1 INTO cnumber;

if c1%notfound then
cnumber := 9999;
end if;

CLOSE c1;

RETURN cnumber;

END;

SQL tutorial: Union and Union All SQL Set Operator In Oracle Database

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.