What is the difference between the implicit and explicit cursors?

DWQA QuestionsCategory: Pl/SQLWhat is the difference between the implicit and explicit cursors?
Editor Staff asked 12 months ago

What is the difference between the implicit and explicit cursors?

1 Answers
Editor Staff answered 12 months 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.