Select the best answer. This is an example of what _____ type of cursor? DECLARE l_date DATE; CURSOR c1 IS SELECT TRUNC(SYSDATE) FROM DUAL; BEGIN OPEN c1; FETCH c1 INTO l_date; CLOSE c1; END;
-
Explicit
-
Implicit
-
Select
-
PL/SQL
-
None of the above.
A
Correct answer
Explanation
This is an explicit cursor because it is explicitly declared with the CURSOR keyword, then explicitly opened, fetched from, and closed. Explicit cursors give you fine-grained control over query execution. Implicit cursors are created automatically by Oracle for SQL statements embedded in PL/SQL code (like SELECT...INTO or implicit cursor FOR loops).