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 are the disadvantages of mysql? : Sql dba
What is the usage of when clause in trigger?
What is sqlservr exe?
How do you create a db file?
How do you identify a primary key?
What is nosql db?
What is a sql trace file?
What do you mean by query optimization?
What is the source code of a program?
How many joins in sql?
Can we insert data into materialized view?
How long does it take to learn pl sql?
What is pl sql in dbms?
How to Execute a Package in PL/SQL.?
What is audit logout in sql profiler?