Interested to Buy Any Domain ? << Click Here >> for more details...
Advantages and Disadvantages of Cursor?
- 15 Answers
- 100194 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
how you can get the list of largest tables in a database? : Sql server administration
What are the types of processing and explain each? : sql server analysis services, ssas
what is the system function to get the current user's user id? : Sql server database administration
Tell me something about security and sql azure?
How you can find out if an index is useful to the optimizer?
What is an indice?
What is extended stored procedures?
How to Sync Two SQL Azure Databases?
What are different types of schemas?
How do you migrate data from mssql server to azure?
How to use values from other tables in update statements in ms sql server?
explain different types of constraints? : Sql server database administration
What is index, cluster index and nonclustered index?
application server is slow what may be the problem
Define Business Edition in SQL Azure?
