Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100949 Views
- Polytechnic, TCS, Zenith, I also Faced
- E-Mail Answers
Answer Posted / navneet chandra
Hi All,
In pl/sql if you want perform some actions more than one
records you should user these cursors only. By using these
cursors you process the query records. you can easily move
the records and you can exit from procedure when you
required by using cursor attributes.
disadvantage:
using implicit/explicit cursors are depended by Situation.
If the result set is less than 50 or 100 records it is
better to go for implicit cursors. if the result set is
large then you should use explicit cursors. other wise it
will put burden on CPU.
| Is This Answer Correct ? | 19 Yes | 7 No |
Post New Answer View All Answers
What is inner join? Explain with an example?
What is named calculation? : sql server analysis services, ssas
How to create an identity column?
What are the differences between decimal and float in ms sql server?
What is difference between joins and subqueries?
what is a self join? Explain it with an example? : Sql server database administration
You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?
How can you check the version of sql server?
Explain features and concepts of analysis services?
wat wil hapn if we give the both read and deny read permission to user?
What are the different types of cursor?
How to defragment table indexes?
How do you use a subquery to find records that exist in one table and do not exist in another?
How do I create an extended event in sql server?
What are parameterized reports?
