Oracle SQL,PL/SQL

The Distinction between Implicit and Explicit Cursors

Difference between Implicit and Explicit Cursors
Avatar of shohal
Written by shohal

Difference between Implicit and Explicit Cursors:

Implicit Cursor: When select commands are executed, implicit cursors are created automatically.

Explicit Cursor: The user must define explicit cursors by giving them a name.

Implicit Cursor: They can only retrieve a single row at a time.

Explicit Cursor: Multiple rows can be retrieved by using explicit cursors.

Implicit Cursor: After execution, it automatically closes.

Explicit Cursor: Need to close after execution.

Implicit Cursor: implicit Cursors are characterized as:

BEGIN

SELECT attr_name from table_name

where CONDITION;

END

Explicit Cursor: Explicit Cursors are characterized as:

DECLARE
CURSOR cur_name IS
SELECT attr_name from table_name 
where CONDITION;
BEGIN
...

🚀
The Distinction between Implicit and Explicit Cursors | TechTweet

 If you’d like me to proceed with any of these, please just let me know from the site techtweet.xyz! Also if you need to learn something new than subscribe YouTube : ASP.NET With SQL SERVER

About the author

Avatar of shohal

shohal

I have profession and personal attachment with custom ERP Software development, Business Analysis, Project Management and Implementation almost (36) ,also Oracle Apex is my all-time favorite platform to developed the software. Moreover i have some website development experience with WordPress. For hand on networking experience DevOps and CCNA, it create me a full package. Here are some core programming language with networking course i have been worked: Oracle SQL ,PL/SQL,Oracle 19c Database , Oracle Apex 20.1,WordPress,Asp.Net ,MS SQL ,CCNA ,Dev Ops, SAP SD

Leave a Comment