what are the advantages of cursors than procedures?
Answer Posted / somashekhar m
By using cursors It is possible to fetch row by row, when
user might want to work with rows one at a time. But not
possible with SQL standard statements it is not possible to
go row by row fetching.
A cursor can be defined as is a set of rows together with a
pointer that identifies a current row.
in ACID cursor works for consistency of the data.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
what are the types of subquery? : Sql dba
What is the order of sql select?
what are the advantages of mysql in comparison to oracle? : Sql dba
How many types of sql are there?
what are the features and advantages of object-oriented programming? : Sql dba
How does pl sql work?
How is data stored in sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
how to drop an existing index in mysql? : Sql dba
What is the main difference between sql and pl/sql?
Where not exists in sql?
Explain constraints in sql?
what are string data types? : Sql dba
what is normalization? : Sql dba
What is the maximum number of rows in sql table?