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:

DECLARE
rows_deleted NUMBER;
BEGIN
DELETE * FROM tblUser WHERE firstName LIKE 'd%';
rows_deleted := SQL%ROWCOUNT;
END;      

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