Give which cursor is better for better performance means
type of cursors?
- 2 Answers
- 6691 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a temporal table?
What is compound trigger?
What has stored procedures in sql and how we can use it?
what is the difference between $message and $$message? : Sql dba
Does truncate release storage space?
What are different types of keys?
How do I view tables in mysql?
Why do we use sqlite?
What is function and procedure?
What are schema-level triggers?
How are sql commands classified?
Can a commit statement be executed as part of a trigger?
What is exception? What are the types of exceptions?
Can we use the cursor's to create the collection in PL/SQL?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
