How collections are improve the performance?
Answer / kesava
Collection contains number of user defined types which is
stored number of data items in Single unit.
Why introduce Collection:
--->When ever we are using cursor memory area control does not get it back from Active set Area.
=====>when ever we are using Collection we are operating
element and also we are moving forward and reverse directions with in memory are using Collection
index by Table
|Is This Answer Correct ?||0 Yes||2 No|
I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?
what is the functionality of the function htmlentities? : Sql dba
What is audit logout in sql profiler?
Does execute immediate commit?
What is difference between TRUNCATE & DELETE?
What is spool?
What are types of joins?
Which type of cursor is used to execute the dml statement?
What is the difference between subquery and correlated query?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How do you modify a table in sql?
What is the difference between rollback and rollback to statements?