Interested to Buy Any Domain ? << Click Here >> for more details...
Give which cursor is better for better performance means
type of cursors?
- 2 Answers
- 7603 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 |
I want to execute a piece of code before calling a procedure. How to achieve it?
Can we write ddl statements in functions?
What is the difference between left outer join and left join?
How to run sql statements with oracle sql developer?
What is sqlite used for?
display null value rows with out using null function?
How do I find duplicates in a single column in sql?
How do I access sql anywhere database?
What is exit statement?
What is a pragma statement?
What is query syntax?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
-
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)
