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

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.

Question Posted / balaji g

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 there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

what is an index? : Sql dba

0 Answers  

how to drop an existing index in mysql? : Sql dba

0 Answers  

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

what is a table in a database ? : Sql dba

0 Answers  

Can you do multiple joins in sql?

0 Answers  

What can I use instead of union in sql?

0 Answers  

What is clustered and non-clustered indexes?

4 Answers   Microsoft,

Is vs as in pl sql?

0 Answers  

Can we use having without group by in sql?

0 Answers  

How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?

0 Answers  

Differentiate between sga and pga.

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories