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
Explain what is a view?
What is a database? Explain
How do you write a subquery?
What is procedure explain with program?
explain what is mysql? : Sql dba
How do you create an update query?
What is the difference between sql and t sql?
How to create an array in pl/sql?
what is timestamp in mysql? : Sql dba
How can I change database name in sql?
Which join is default?
What is raid? How does it help storage of databases?
Is time a data type in sql?
what are tables and fields? : Sql dba
Enlist the data types that can be used in pl/sql?