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

2018-02-01, 402👍, 0💬

Popular Posts:

Verifying SQL Server...

How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

FLOOR, CEILING, ROUN...

How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...

CREATE TABLE - Creat...

How to create new tables with "CREATE TABLE" statements in SQL Server? If you want to create a new t...

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...