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 does a pl/sql package consist of?
How to display the records between two range in Oracle SQL Plus?
How can you know that statistics should be updated?
What sql database should I use?
Differentiate between sga and pga.
explain what is mysql? : Sql dba
Name some usages of database trigger?
When is a declare statement required?
What is the difference among union, minus and intersect?
Explian rowid, rownum?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
explain the delete statements in sql
what is the difference between nested subquery and correlated subquery?
Why do we need pl sql?
Are null values same as that of zero or a blank space?