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's the difference between a primary key and a clustered index?
Is crud a cuss word?
What does closing a cursor do?
How to convert comma separated string to array in pl/sql?
What is the purpose of using pl/sql?
What is autocommit sql?
What are crud methods?
Define join and name different types of joins?
What is a procedure in pl sql?
What is the difference between numeric and autonumber?
What is the difference between instead of trigger and after trigger?
What does joining a thread mean?
Which normal form is best?
What is pl sql script?
Are subqueries better than joins?