PL/SQL Cursor Definition in Oracle Database

Опубликовано: 09 Октябрь 2024
на канале: rejawebs

187

►►► Title: PL/SQL Cursor Definition in Oracle Database

►►► Contents:
Cursor:
-----------
A cursor is a pointer to the data. A cursor can store the data in PGA and it is session specific.
Depending on use, there are types of cursors..

01. Implicit Cursor:
a. Implicit cursors are automatically created when select statements are executed.
b. They are capable of fetching a single row at a time
c. Closes automatically after execution.
d. Provides less programmatic control to the users
e. Implicit Cursors are defined as:
BEGIN
SELECT attr_name from table_name
where CONDITION;
END;

02. Explicit Cursor:
a. Explicit cursors needs to be defined explicitly by the user by providing a name.
b. Explicit cursors can fetch multiple rows.
c. Need to close after execution.
d. User/Programmer has the entire control.
e. Implicit Cursors are defined as:
DECLARE
CURSOR cur_name IS
SELECT attr_name from table_name
where CONDITION;
BEGIN
OPEN cur_name;
FETCH cur_name INTO VARIABLES;

CLOSE cur_name;
END;

►►► Topics
PL/SQL Cursor Definition in Oracle Database,CURSORS IN PL/SQL WITH EXAMPLES | PL/SQL TUTORIAL,Introduction to PL/SQL Cursor,
Introduction to PL SQL Cursor || Oracle PL/SQL,Oracle - PL/SQL - Implicit Cursors,What is cursor and types of cursor and Implicit cursor,
Cursor & Function in Oracle PL/SQL,Introduction to Cursor in PL/SQL Oracle,PLSQL Cursor, Implicit and Explicit Cursor, How to Open, Fetch, Close Cursor,
Oracle PL/SQL Full Course,Oracle Database Course - PLSQL Anonymous Block and Variable Declaration,What are Cursor Parameters in PL SQL,
Oracle PLSQL - CURSOR (Implicit and Explicit),PL/SQL Cursor,

🔗Content🔗: https://github.com/rezaice07/youtube-...

🔗LINKS🔗
Website: http://rejawebs.com/#/
LinkedIn: / md-rezoyanul-islam-096a3775

►►► Find me on Social Media◄◄◄
Facebook: / rezoyanul.reza

✉ Contact with me
Email: [email protected]

❤ Make sure you SUBSCRIBE and be the 1st one to view newly created videos!

Hope you guys enjoyed this tutorial..
Don't forget to subscribe my channel.
Keep watching the next tutorial.
Thanks