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

How many tables can you join in sql?

0 Answers  

How to return more than one value from a function?

11 Answers   Satyam,

how to concatenate two character strings? : Sql dba

0 Answers  

What is a temp table?

0 Answers  

What is string join?

0 Answers  

Which join is default?

0 Answers  

How collections are improve the performance?

1 Answers   Polaris,

What is the maximum number of rows in sql table?

0 Answers  

With out using count() function. How to the find total number of rows in a table?

6 Answers  

How to use distinct and count in sql query? Explain

0 Answers  

What is varchar data type in sql?

0 Answers  

What is pl sql variable?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories