How Many Types of Cursors Supported in PL/SQL

Q

How Many Types of Cursors Supported in PL/SQL? - Oracle DBA FAQ - Working with Cursors in PL/SQL

✍: FYIcenter.com

A

PL/SQL supports two types of cursors:

  • The implicit cursor - A single default cursor that automatically connects to the last DML statement executed.
  • Explicit cursors - User defined cursors with specific DML statements and execution statuses.

2007-04-29, 4861👍, 0💬