Menu

Showing posts with label PLSQL. Show all posts
Showing posts with label PLSQL. Show all posts

Cursor in PLSQL

 The cursor is a private work area for an SQL statement, when the SQL statement is executed in PL/SQL block, the Oracle engine assigns a private work area for that statement. The cursor stores the statement and result after execution.

There are two types of Cursor implicit cursor and explicit cursor.

Example of Implicit Cursor

DECLARE

    var datatype

BEGIN

    select * from table; // Your SQL statement

END;


Example of Explicit Cursor

DECLARE

             CURSOR cursor_name is

                select * from table;    // Your SQL statement 

BEGIN

    OPEN cursor_name; 

        FETCH cursor_name  // Your SQL statement

            CLOSE cursor_name; 

END;


Reference

 Cursor overview | Oracle Doc