Close Cursor In PLSQL

A Cursor in Oracle PLSQL is basically a memory area, in which the records or results fetched by an SQL SELECT Statement can be stored. The last step in working with CURSOR in Oracle PLSQL is to CLOSE the CURSOR once we have finished processing the records of the CURSOR. CLOSE CURSOR Syntax CLOSE cursor_name; … Continue Reading

Attributes of CURSOR in Oracle PLSQL

The attributes of cursor in Oracle PLSQL helps us to determine the state or status of a cursor. Below is the list of attributes of cursors that we can use in Oracle PLSQL to determine the status of cursor. Attribute Explanation %ISOPEN If the cursor is open the %ISOPEN returns TRUE, else returns FALSE. %FOUND … Continue Reading

CLOSE CURSOR in Oracle PLSQL

The CLOSE CURSOR in Oracle PLSQL is used when we have finished processing the records of the CURSOR. Syntax to use CLOSE CURSOR in Oracle SQL / PLSQL is: CLOSE cursor_name; Let’s understand, how to CLOSE CURSOR from the help of the below Oracle PLSQL function The statement CLOSE cur_salary; will be used to close … Continue Reading