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 scalar function?
What is online transaction processing (oltp)?
How can we make an if statement within a select statement?
What is data abstraction in sql?
What is blind sql injection?
What are the built in functions of sql?
what is data integrity? : Sql dba
Which command is used to delete a package?
What is the main difference between sql and pl/sql?
Explain the difference between sql and mysql.
How much does sqlite cost?
What is sqlcommand?
Write the alter statement to enable all the triggers on the t.students table.
What is the difference between rename and alias?
What is set serveroutput on?