Showing posts with label Cursor. Show all posts
Showing posts with label Cursor. Show all posts

Wednesday, January 10, 2024

Cursors in PL/SQL | Oracle PL/SQL Cursors | Cursor | Implicit Cursor | Explicit Cursor | %NOTFOUND | %FOUND | %ISOPEN | %ROWCOUNT

 

Cursors

  • Cursors can be defined as private memory where the data stores temporarily.  
  • Cursors are used to process the multiple records. 
  • Cursors holds the multiple rows which is written in SQL statement.

Data base contains two static cursors

1. Implicit Cursor.

2. Explicit Cursor.

Implicit Cursor:

  • In Implicit Cursor the DML operations will be performed. 
  • The implicit cursor cannot be named and they cannot be controlled and referred to another place.
  • We can refer the implicit cursor through the attributes only.