Advantages and Disadvantages of Cursor?
Answers were Sorted based on User's Feedback
Answer / vivekanand
Merits: Row by Row Validations, good choice for small set of records
De-Merits: it Increases Network Traffic, result to slowdown the Speed and Performance of the Database,
Consumes More Resources, bad choice for large set of records.
Cheers,Vivekanand
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / sandeep singh
Advantages:
Cursors are somewhat like Pointers of Oracle, Oracle executes a query and assign some name to that memory location, which is known as Cursor.
Cursors are used for storing data temperarorily.
Cursors are used for storing, managing and retrieving data.
Cursors stores in the RAM so the data access and retrieval is fast.
Disadvantage:
No such disadvantage. Only thing is that rather than storing data in an intermediate variable and fetching it one by one via cursor and then processing it sequentially, we can use Collections. By using collections, we can pass the bundle of Data at once.
Is This Answer Correct ? | 2 Yes | 0 No |
as per my Knowledge cursor is data type which is used to
define multivalue variable.if u take int a ,here a is
static variable which hold only one value at a time.in some
situvations we need data type variable which hold
multivalues
if any one find new answer ,send me
nag.mca08@gmail.com
Is This Answer Correct ? | 28 Yes | 89 No |
How to drop an existing user defined function in ms sql server?
How to convert numeric values to integers in ms sql server?
What is indexing in sql server with example?
hi, i have a table called names and field name select * from names name a b c d i want to display like this name a,b,c,d how it is possible Regards Baiju
wat new abt truncate in sql server
What is auditing in sql server?
What is advantage data architect?
How the authentication mode can be changed?
How to list all user names in a database?
Does view occupy space?
Explain system scalar functions?
What is 4nf in normalization form?