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

Main diff between varray and nested tablea

Question Posted / ganesh

Answers were Sorted based on User's Feedback



Main diff between varray and nested tablea..

Answer / srinivas

We should give the maximum size when we declare the varry, and if u perform delete then it removes the values from the end, use this varray when u know the size


we no need to give the size when we declare the nested tables,we can remove the values any where from the nested table,use this when u don't know the size.

Is This Answer Correct ?    4 Yes 0 No

Main diff between varray and nested tablea..

Answer / dandu devendra

Varray: constrain table.Basically this table dense by default indexs start with 1.
Nested table: unconstrain table.

Is This Answer Correct ?    3 Yes 2 No

Main diff between varray and nested tablea..

Answer / 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

More SQL PLSQL Interview Questions

How many rows will return from dual table?

4 Answers   Fujitsu,

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

Explain table and field in sql?

0 Answers  

What language is oracle sql developer?

0 Answers  

How to remove duplicate rows from a table?.

3 Answers  

How is indexing done in search engines?

0 Answers  

Can pl sql procedure have a return statement?

0 Answers  

What is data control language (dcl)?

0 Answers  

What is a sql select statement?

0 Answers  

What is a procedure in pl sql?

0 Answers  

Is sql free?

0 Answers  

What is embedded sql in db2?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories