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

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

What is schema in sql example?

0 Answers  

What is a column in a table?

0 Answers  

What are the triggers associated with image items?

0 Answers  

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

What is trigger in flip flop?

0 Answers  

How do you update a table in sql?

0 Answers  

What is the main difference between sql and pl/sql?

0 Answers  

What is an Integrity Constraint?

4 Answers  

What is offset in sql query?

0 Answers  

What are inner outer left and right joins in sql?

0 Answers  

What is correlated sub-query?

7 Answers   Oracle,

For more SQL PLSQL Interview Questions Click Here
Categories