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
What is a field name?
What is the default Port No on which SQL Server listens?
What are the types of subquery?
What is the main purpose of having conversation group?
tell me the disaster recovery plan
What is sql server profiler?
what is a check constraint?
Which joins are sql server default?
What are 3 ways to get a count of the number of records in a table?
How to drop existing views from a database in ms sql server?
Can we insert data into a view?
How to disable a login name in ms sql server?
What are the types of resultset?
What are the advantages of paper records?
What is an indexing technique?