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
Where is sql database stored?
What is a table?
What is the size of partition table?
how to get help information from the server? : Sql dba
When is the explicit cursor used ?
Explain polymorphism in pl/sql.
what is rdbms? : Sql dba
Is sql between inclusive?
What is the difference between functions, procedures, and packages in pl/sql?
What is prepared statement in sql?
What is the requirement of self-join?
What is a temporal data type?
What are the types pl/sql code blocks?
What is the difference between rename and alias?
How many sql core licenses do I need?