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

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / sweetsarao


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 snowflake sql?

0 Answers  

How do I debug a stored procedure?

0 Answers  

What is 19 null in sql?

0 Answers  

Can we edit a view in sql?

0 Answers  

What are the types of functions in sql?

0 Answers  

Types of backups ?

3 Answers   TCS,

Why select is used in sql?

0 Answers  

Explain the order of sql statement execution?

0 Answers  

Why use stored procedures?

0 Answers  

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

How to read xml file in oracle pl sql?

0 Answers  

How do I order by ascending in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories