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

what is 'mysqlimport'? : Sql dba

0 Answers  

How do you identify a primary key?

0 Answers  

What is an exception in pl/sql?

0 Answers  

I have a tablle like this. cust acc --------------- a 1 b 2|3 c 4|5|6 I Want below o/p: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 Please any one can you have any ideas share me. I have urgent requirement.

4 Answers   Cap Gemini, MTS,

What does data normalization mean?

0 Answers  

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

What is the usage of distinct keyword?

0 Answers  

what is the need of the cursor attribute notfound..(because using found attribute we can complete the task......found + negation operator = not found )

2 Answers   Tech Mahindra,

How do you bind variables in pl sql?

0 Answers  

How does a trigger work?

0 Answers  

If the base table structure is changed what will happen to join index????

2 Answers  

Can ddl statements be used in pl/sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories