Oracle - Types of Cursors Supported in PL/SQL in Oracle

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, 187👍, 0💬

Popular Posts:

Passing Values to St...

How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedu...

What Are Logical/Boo...

What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...

About dba.FYIcenter....

What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...

Error: Imported Tabl...

What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...

CONVERT() - Converti...

How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL...