What is the difference between the implicit and explicit cursors?

Category: Pl/SQLWhat is the difference between the implicit and explicit cursors?
Editor">Editor Staff asked 2 years ago

What is the difference between the implicit and explicit cursors?

1 Answers
Editor">Editor Staff answered 2 years ago

Implicit cursor is implicitly declared by Oracle. This is a cursor to all the DDL and DML commands that return only one row.
Explicit cursor is created for queries returning multiple rows.