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
- 16199 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
How can you get sql*loader to commit only at the end of the load file? : aql loader
How many types of indexes are there in sql?
Write a sql query to convert all character to uppercase after hypen.
Why use triggers in sql?
Does sql*plus also have a pl/sql engine?
What are different categories of sql commands?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How many triggers can be applied to a table?
How do I start sql from command line?
Is sql a oracle?
What is the location of pre_defined_functions.
What is full join in sql?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
Can %notfound return null after a fetch?
What does dml mean?
