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


why should required nested tables, Object types, partition
tables and varying arrays. what is the difference between
these are all. give me example with explanation.

Answers were Sorted based on User's Feedback



why should required nested tables, Object types, partition tables and varying arrays. what is the ..

Answer / suresh kumar somayajula

V-Array is an Ordered set of elements.It's having Maximum
size and you can't delete individual elements. V-Arrays are
dense.

Nested Table is an un-orderes set of elements.It doesn't
have maximum size and you can delete individual elements
from Nested Tables . Nested Table can be Parse.

Is This Answer Correct ?    0 Yes 0 No

why should required nested tables, Object types, partition tables and varying arrays. what is the ..

Answer / manoranjan sethy

If you want to declare fixed element then use varray.
If you want to declare any number of element at run time then use nested table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is sql easier than java?

0 Answers  


can we update a view which is created from two tables

11 Answers  


Why is pl sql used?

0 Answers  


What is difference between pls_integer and integer?

0 Answers  


What is sqlite used for?

0 Answers  


what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,


What are the advantages of indexing?

0 Answers  


If we update a complex view, is base table will get update ?

2 Answers   Ardee Technologies, HCL,


What is range partitioning?

0 Answers  


what are rollup and cube in t-sql? : Transact sql

0 Answers  


What is the difference between between and in condition operators?

0 Answers  


Can we write create command in the plsql block?if possible how?

2 Answers  


Categories