what are the advantages of cursors than procedures?
- 2 Answers
- 11234 Views
- I also Faced
- E-Mail Answers
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 functions in sql?
What are aggregate and scalar functions?
How do I count records in sql?
What is database migration?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
What is query syntax?
How do you write an index?
how do you know the version of your mysql server? : Sql dba
What is meaning of <> in sql?
What is information schema in sql?
How do I know if I have sql express or standard?
What is pl/sql table? Why it is used?
What is meant by user defined function?
Show the cursor attributes of pl/sql.
what is transaction? : Sql dba
