Give which cursor is better for better performance means
type of cursors?
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 |
define sql insert statement ? : Sql dba
What is an exception in pl/sql?
What can you do with pl sql?
what is a materialized view? : Sql dba
Is a table valued function object?
In a package if we have 10 procedures or functions,How to know which will execute first?
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.
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?
What is sql and db2?
i have doubt that any one tell ref cursor comes in sql pl/sql? pls clarify?
What is the basic difference between a sql and stored procedure ?