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

Explain what is table in a database?

0 Answers  

What is before trigger?

0 Answers  

Enlist the data types that can be used in pl/sql?

0 Answers  

What are different types of indexes?

0 Answers  

Can you have more than one key in a database?

0 Answers  

What is difference between inner join and cross join?

0 Answers  

What is difference between my sql and sql?

0 Answers  

what is data control language? : Sql dba

0 Answers  

Is clustered index a primary key?

0 Answers  

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,

For more SQL PLSQL Interview Questions Click Here
Categories