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 and vector?
What does <> sql mean?
What is normalization in a database?
Explain the difference between triggers and constraints?
What are the two types of periodical indexes?
What is primary key secondary key alternate key candidate key?
What is difference between stored procedures and application procedures?
What is a join?
What are the different types of database management systems?
What is gpt format?
What are the rules to be applied to nulls whilst doing comparisons?
What type of database is cloud sql?
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is cold data?
Explain what is sql?