Create cursor | Types | Implicit and Explicit cursor | PL/SQL | Oracle | Tutorial - 16 | Tamil

Cursor

---------------

Oracle creates Memory Area (Context Area) for processing SQL Statements
Cursor is pointer for this context area

Types:
1. Implicit cursors
%FOUND
%NOTFOUND
%ROWCOUNT
2. Explicit cursors

-------------------------

Implicit cursor
Programmers defined cursor to gain more control over context area

----------------------------

Explicit cursor
1. Create Cursor
2. Open Cursor
3. Fetch cursor
4. Close Cursor

----------------------------
chapter

0:00 Introduction
0:14 Context area memory
0:56 Cursor Types
1:04 Implicit cursor
5:58 Explicit cursor

---------------------------

sql tutorial for beginners in tamil, interview questions and answers for experienced and for freshers, sql full course, sql tutorial, sql lecture, pl/sql interview questions and answers, oracle sql tutorial, oracle interview questions and answers for experienced.

#மைக்காடெக் #micah #kirubason #கிருபாசன்

[vanathivans]

Yes bro matha padi romba na teach pandringa