Interested to Buy Any Domain ? << Click Here >> for more details...
Give which cursor is better for better performance means
type of cursors?
- 2 Answers
- 7673 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / swapna
If you deal with better performance You have to refer REF
CURSOR and its more advantage and effecient of Execution.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rahul koshti
Definitely...Implicit cursors =>
Because From Release PL/SQL 2.3 ( Oracle 7.3 and earlier)
and above , Implicit cursors has been optimized therefore it
runs faster than the Explicit cursor.
| Is This Answer Correct ? | 1 Yes | 1 No |
How well can multiple sessions access the same data simultaneously ?
What is sqlca in db2?
Can sql developer connect to db2?
What is trigger and how to use it in sql?
Does user triggers have entry for trigger with compilation errors?
What is the difference between delete and truncate statement in sql?
What is left inner join in sql?
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.
What is sql mysql pl sql oracle?
How do you create a db file?
What are sql functions? Describe the different types of sql functions?
What are the triggers associated with image items?
-
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)
