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
- 16240 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 we optimize or increase the speed of a mysql select query? : Sql dba
What is sql and db2?
Explain correlated query work?
how can we repair a mysql table? : Sql dba
What are stuff and replace function?
How global cursor can be declare with dynamic trigger ?
what are the types of subquery? : Sql dba
Does mysql_real_escape_string prevent sql injection?
What does truncate mean in sql?
How does join work in sql?
Can we create foreign key without primary key?
What is online transaction processing (oltp)?
Write a sql query to get the third highest salary of an employee from employee_table?
What is cost in sql execution plan?
How do you truncate?
