Advantages and Disadvantages of Cursor?
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
Difference between group by clause and having clause in SQL?
Explain linked server in sql?
what stored procedure would you use to view lock information? : Sql server administration
What is checkpoint in sql server?
Explain ms sql server reporting services vs crystal reports?
What is the order in which the sql query is executed?
Can we call future method from queueable?
What are the different types of backups that exist?
Which language is supported by sql server?
How many types of the database links?
What is normalization of database? What are its benefits?
Explain what role entity and relationship play in an ER diagram.
Can sql servers linked to other servers like oracle?
What is model database in sql server?
what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration