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
What is data type in sql?
What are different categories of sql commands?
Does group by remove duplicates?
Does truncate require commit?
How sql query is executed?
What is a stored procedure in sql with example?
What does an inner join do?
What is string data type in sql?
Why primary key is required?
What is the use of <> sql?
Is delete faster than truncate?
List the various privileges that a user can grant to another user?
What is rename command in sql?
What are the different types of triggers?
I need a function for a train ticket reservation please answer it thanks in advance