Give which cursor is better for better performance means
type of cursors?

Answers were Sorted based on User's Feedback



Give which cursor is better for better performance means type of cursors?..

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

Give which cursor is better for better performance means type of cursors?..

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

Post New Answer

More SQL PLSQL Interview Questions

define sql insert statement ? : Sql dba

0 Answers  


What is an exception in pl/sql?

0 Answers  


What can you do with pl sql?

0 Answers  


what is a materialized view? : Sql dba

0 Answers  


Is a table valued function object?

0 Answers  






In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,


i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,


How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?

28 Answers   Alps, Aricent, Bank Of America, Wipro,


What are the different datatypes available in PL/SQL?

0 Answers  


What is sql and db2?

0 Answers  


i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?

4 Answers   Tech Mahindra,


What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,


Categories