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

Can we use threading in pl/sql?

1034


Is it possible to include an insert statement on the same table to which the trigger is assigned?

1009


Why partition by is used in sql?

1030


what is the command used to fetch first 5 characters of the string? : Sql dba

1634


How exception handling is done in advance pl/sql?

978


Why does sql need a server?

1030


How can you create an empty table from an existing table?

1068


Explain ttitle and btitle.

1116


Write a sql query to find the names of employees that begin with ‘a’?

1001


what is index? : Sql dba

998


What are all the different types of indexes?

1145


which operator is used in query for pattern matching? : Sql dba

1002


what is the command line end user interface - mysql? : Sql dba

978


Does inner join return duplicate rows?

970


How to rename a column in the output of sql query?

1070