PL/SQL declares a cursor implicitly for all SQL data manipulation statements, including quries that return only one row. However,queries that return more than one row you must declare an explicit cursor or use a cursor FOR loop.Explicit cursor is a cursor in which the cursor name is explicitly assigned to a SELECT statement via the CURSOR...IS statement. An implicit cursor is used for all SQL statements...

Manjunath

• Sep 1st, 2015

Hello, Given example PL/SQL program is comes under Implicit, Bcz 1. if its Explicit then cursor has to be declared in declarative part along with SELECT statement to retrieve the data from Database ...

Justo

• Jul 15th, 2015

Its an implicit cursor.

Answer Question  Select Best Answer