Types of Cursors Supported in PL/SQL in Oracle

Q

How Many Types of Cursors Supported in PL/SQL in Oracle?

✍: 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.

 

⇒Working with Cursors in Oracle PL/SQL

⇒⇒Oracle Database Tutorials

2016-10-17, 164👍, 0💬

General MySQL Oracle SQL Server