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
- 16593 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 type and rowtype in pl sql?
What are some emotional triggers?
how do you know if your mysql server is alive? : Sql dba
discuss about myisam index statistics collection. : Sql dba
What is synonyms?
What is view explain with example?
Mention what plvcmt and plvrb does in pl/sql?
What is pl sql script?
What is union, minus and interact commands?
What is spool?
What is the maximum size of sqlite database?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
how many values can the set function of mysql take? : Sql dba
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Which is better stored procedure or query?
