Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of cursor ? how cursor allocate context area for executing the sql statement?
- 4 Answers
- 16437 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
discuss about myisam key cache. : Sql dba
What is sql scripting?
What are the benefits of pl/sql packages?
What is the current version of sql?
What is a temporal data type?
What is informix sql?
What does partition by mean in sql?
Can I join the same table twice?
What is sqlexception in java?
Which is faster subquery or join?
How does rowid help in running a query faster?
What is sql key?
What is a table partition?
What is the difference between left join and right join?
Why do we use joins?
