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
Does a primary key have to be a number?
Is it possible to read/write files to-and-from PL/SQL?
What is program debugging?
What are inner outer left and right joins in sql?
How to select random rows from a table?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
What is the importance of sqlcode and sqlerrm?
What is the best free sql database?
How to raise user-defined exception with custom sqlerrm ?
What is a database event trigger?
Why we use join in sql?
Can we change the table name in sql?
What is a natural join sql?
What is varchar example?
Define union, minus, union all, intersect ?