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

Popular Posts:

CHARINDEX() and SUBS...

How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...

READ_ONLY/READ_WRITE...

How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...

MySQL Database Tutor...

Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...

DATEADD() Function U...

How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...

DROP_EXISTING - Recr...

How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...