Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of cursors than procedures?
- 2 Answers
- 12117 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 does select count (*) mean in sql?
What are actual parameters and formal parameters?
Can a key be both primary and foreign?
How to execute a stored procedure?
Does view contain data?
What is indexes?
How do you create a db file?
What is sql analyzer?
How do I remove sql developer from windows 10?
What are the methods of filing?
What is the purpose of a sql?
What is pl sql block in dbms?
What are the advantages of pl sql?
Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?
Can there be 2 primary keys in a table?
