Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of cursors than procedures?
- 2 Answers
- 11943 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 kind of join is join?
What is the difference between unique and primary key constraints?
Is sql low level language?
What is Collation Sensitivity ? What are the various type ?
what is 'mysqldump'? : Sql dba
what is union, minus and interact commands? : Sql dba
how to add a new column to an existing table in mysql? : Sql dba
Difference between table function and pipelined function?
What is nosql example?
What is pls integer?
Do foreign keys improve performance?
What are the different ways to optimize a sql query?
How do rank () and dense_rank () differ?
How does stored procedure reduce network traffic?
What is before trigger?
