Give which cursor is better for better performance means
type of cursors?
- 2 Answers
- 7112 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 trigger with example?
What is the difference between local and global temporary table?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
How to create a menu in sqlplus or pl/sql?
What is interval partition?
what is log shipping? : Sql dba
What is gpt format?
Which command is used to delete a trigger?
Can there be 2 primary keys in a table?
what is a trigger in mysql? : Sql dba
How many subqueries can be nested in a statement?
Why cannot I use bind variables in ddl/scl statements in dynamic sql?
What are the parameter modes supported by pl/sql?
Why triggers are used?
What is materialized view in sql?
