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



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

Answer / 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

More SQL PLSQL Interview Questions

what is acid property in database? : Sql dba

0 Answers  


Can we have exception part in trigger ?

1 Answers  


Is t sql a programming language?

0 Answers  


what is ref cursor in pl/sql?

3 Answers  


How do you explain an index?

0 Answers  


How to select all records from the table?

0 Answers  


Which data type is a composite type?

0 Answers  


What are the types of join in sql?

0 Answers  


how do you control the max size of a heap table? : Sql dba

0 Answers  


What is the difference between inner join and natural join?

0 Answers  


what is 'mysqladmin' in mysql? : Sql dba

0 Answers  


----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6

4 Answers   ICICI,


Categories