Interested to Buy Any Domain ? << Click Here >> for more details...
State the advatage and disadvantage of Cursor's?
- 2 Answers
- 9587 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / shilpa.oracle
Advantage:
Using cursors we can retrieve multiple records in a plsq block.
Disadvantage:
switching between the plsql statement executor and sql
statement executor at plsql runtime engine will consume time.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / swapna
advantage :
In pl/sql if you want perform some actions more than one
records you should user these cursors only. By using these
cursors you process the query records. you can easily move
the records and you can exit from procedure when you
required by using cursor attributes.
disadvantage:
using implicit/explicit cursors are depended by Situation.
If the result set is les than 50 or 100 records it is
better to go for implicit cursors. if the result set is
large then you should use exlicit cursors. other wise it
will put burdon on cpu.
| Is This Answer Correct ? | 5 Yes | 1 No |
Is sql database free?
how to create a database in oracle?please gve anser with example
How many sectors are in a partition?
Define concurrency control. : Transact sql
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
Can we delete column in sql?
What is the difference between left and left outer join?
Explain the difference between 'between' & 'and' operators in sql
Is sql difficult?
What is sqlite used for?
How do you drop a trigger?
What is sql and its types?
-
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)
