What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 14881 Views
- HCL, I also Faced
- E-Mail Answers
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 memory optimized table?
how to add a new column to an existing table in mysql? : Sql dba
What is the difference between a primary key and a unique key?
what is auto increment? : Sql dba
What is a rank in sql?
Is sql port 1433 encrypted?
What are the advantages of pl sql?
i have some prob lem to tell me about my self in interview first round ...
Can we create clustered index without primary key?
What is nvarchar max in sql?
How do you clear the screen in sql?
What information is needed to connect sql*plus an oracle server?
What is meant by <> in sql?
What is auto increment in sql?
What is application trigger?
