How collections are improve the performance?
Answer Posted / kesava
COLLECTION:
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
collection Types:
index by Table
Nested Table
Varray
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Is sql free?
What is a string data type in sql?
Can we enter data in a table in design view?
what are the different functions in sorting an array? : Sql dba
What are schema-level triggers?
Where are my tempfiles, I don't see them in v$datafile or dba_data_file?
What is difference sql and mysql?
What is the example of procedure?
Is vs as in pl sql?
What is difference between hql and native sql?
What is group by in sql?
Can we call a function containing dml statements in a select query?
Write the alter statement to enable all the triggers on the t.students table.
What is an implicit commit?
how to decrement dates by 1 in mysql? : Sql dba