Advantages and Disadvantages of Cursor?
- 15 Answers
- 96662 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
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
Mention the differences between sql server and mysql.
What are the different types of stored procedures?
What is policy management?
explain the storage models of olap? : Sql server database administration
What are the requirements to use odbc connections in php scripts?
How to delete multiple rows with one delete statement in ms sql server?
What do you mean by normalisation?
What are the different authentication modes in sql server? How can it be changed?
What stored procedure can you use to display the current processes?
what is a traditional network library for sql servers? : Sql server database administration
What is raiseerror? What is raiseerror?
How to write character string constants or literals in ms sql server?
What are the advantages of using stored procedures in sql server?
What are the differences between local and global temporary tables?
