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 the best sql course?
how to drop an existing index in mysql? : Sql dba
What are triggers and its types?
Is nosql relational?
What is native sql query?
What are the steps for performance tuning.
Explain what is a column in a table?
What are the 3 modes of parameter?
How do I create a memory optimized filegroup?
What is autocommit sql?
What are sql injection vulnerabilities?
How to read/write files from pl/sql?
How to call a javascript function from pl sql?
How long does it take to learn pl sql?
What is meant by user defined function?