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

Popular Posts:

RAND() - Generating ...

How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...

Managing Security, L...

Where to find answers to frequently asked questions on Managing Security, Login and User in SQL Serv...

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...

Creating a View with...

Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data ...

Unicode Character St...

How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...