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

Main diff between varray and nested tablea

Answer Posted / prabu t

Varray -
Can be stored in the database.
Bounded (maximum length should be given).
Delete / Remove values only from the end.

Nested Tables -
Cannot be strored in the database.
Unbounded (No maximum length).
Delete / Remove values anywhere in the table.

Is This Answer Correct ?    7 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why use truncate instead of delete?

992


How is a process of pl/sql compiled?

1134


What are the query optimization techniques?

914


What are the different set operators available in sql?

1009


What are types of exception?

904


What is sharding in sql?

956


How to order siblings in oracle hierarchy queries?

1022


How to know the last executed procedure?

1071


Does user triggers have entry for trigger with compilation errors?

1019


Define a temp table?

1005


What is the least restrictive isolation level? : Transact sql

1048


what are the 'mysql' command line arguments? : Sql dba

1121


What are the benefits of pl sql?

1106


What is use of term?

1045


What is clustered and nonclustered index in sql?

930