What is the use of cursor ? how cursor allocate context area for executing the sql statement?
Answer Posted / anil kumar jaiswal
cursor :
Oracle create a memory area called context area to execute sql statements. that context area keep all information about the statement processed.
cursor is just a pointer to that context area and you can also say a cursor is pointing to result set of a query.
Types cursor :
1.Implicit cursor : implicit cursor automatically created by oracle when ever there is dml operation performed inside pl/sql block.(dml operation means insert,update,delete).
2. Explicit Cursor : its a user defined cursor, user need to define it explicitly.
cursor declared in declaration section called explicit cursor.
Cursor Attributes : there is 4 types of cursor attributes used.
1.%notfound.
2.%found.
3.%isopen
4.%rowcount.
for more queries contact me on aniljaiswal143@gmail.com.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is pessimistic concurrency control? : Transact sql
define sql delete statement ? : Sql dba
What does sql stand for?
What is the difference between sum and count in sql?
How can the performance of a trigger be improved?
What schema means?
Explain the advantages and disadvantages of stored procedure?
Define concurrency control. : Transact sql
Is sql an operating system?
What is the sql query to display the current date?
What are the different types of triggers?
How do I copy a table in sql?
How to create your own reports in sql developer?
How does left join work in sql?
Can we use delete in merge statement?