PL/SQL Exception

PL/SQL Exception

PL/SQL Interview Questions

PL/SQL Interview Questions and Answers

PL/SQL Implicit Cursor

In PL/SQL a Implicit Cursors are created automatically by Oracle while an SQL statement is executed. In this process, the user is unaware of implicit cursor. Oracle automatically performs the OPEN, FETCH, and CLOSE operations.

PL/SQL Implicit Cursor Example

Create tblCustomerLoan table and have records:

Now, let's create a program and execute to delete the rows if user name start with "d". Here, SQL%ROWCOUNT attribute is used to determine the number of rows affected:


Now, if you check the records in tblCustomerLoan table, you will find that the rows are deleted.