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 is a database trigger ? Name some usages of database trigger ?

4 Answers  

What is the purpose of design view?

0 Answers  

What is intersect?

1 Answers  

Explain the working of primary key?

0 Answers  

what are enums used for in mysql? : Sql dba

0 Answers  




What are the advantages of stored procedure?

0 Answers  

What is program debugging?

0 Answers  

Is truncate ddl or dml?

0 Answers  

What are stored procedures used for?

0 Answers  

how to check myisam tables for errors? : Sql dba

0 Answers  

What is meaning of <> in sql?

0 Answers  

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

For more SQL PLSQL Interview Questions Click Here
Categories