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 is blind sql injection?
What is the cause of mutating table error and how can we solve it?
How does postgresql compare to "nosql"?
What is user in sql?
Can two tables have same primary key?
What is the purpose of primary key?
how to select first 5 records from a table? : Sql dba
what is isam? : Sql dba
How do you get column names only for a table (sql server)?
Compare sql & pl/sql
What is the use of <> sql?
what is a constraint? : Sql dba
What is sql key?
Is sql between inclusive?
What is a full join?