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...

what is the difference between varray and table data
type..please expalain with some examples...

under what situation you will go for varray..instead of
index by table...

Answer Posted / anil kumar jaiswal

the major difference you can say here is bounding.
varray is bounded but index by table is not bounded.
means in varray you can mention the limit but in index by table you cannot.

if you got with performance varray is more effective and faster than index by table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is keyword pl sql?

1054


What is write ahead logging in sql server?

1096


Are stored procedures faster than queries?

988


How does sql developer connect to oracle database?

1048


What is difference between inner join and self join?

1133


what is the difference between truncate and delete statement? : Transact sql

1116


what is 'trigger' in sql? : Sql dba

1142


What is rowid in sql?

1051


What are sql procedures?

1082


What is meant by temporal data?

999


What is the difference between a database and a relational database?

1154


What is rownum in sql?

1091


What is the difference between jpql and sql?

1140


What is a design view?

975


Is the primary key an index?

1074