Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What's the difference between a primary key and a clustered index?

946


Is crud a cuss word?

971


What does closing a cursor do?

1240


How to convert comma separated string to array in pl/sql?

1105


What is the purpose of using pl/sql?

1075


What is autocommit sql?

922


What are crud methods?

969


Define join and name different types of joins?

957


What is a procedure in pl sql?

1125


What is the difference between numeric and autonumber?

938


What is the difference between instead of trigger and after trigger?

947


What does joining a thread mean?

972


Which normal form is best?

895


What is pl sql script?

975


Are subqueries better than joins?

916