Interested to Buy Any Domain ? << Click Here >> for more details...
what are the advantages of cursors than procedures?
- 2 Answers
- 12010 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumar srinivasalu
Cursors can be used to pass the parameters to procedures
and functions. The Single cursor used to multiple
updatation and used multiple queries at run time
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / 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 |
What is bind variable in pl sql?
How do I remove duplicates in two columns?
Is left join faster than join?
How will you make performance better for application including front end and back
What are the usage of SAVEPOINTS?
What are the sql aggregate functions?
How do I create a memory optimized filegroup?
Is sqlexception checked or unchecked?
How many types of cursors are available in pl/sql?
what is global table
How many sql are there?
What is a record in pl/sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
