Main diff between varray and nested tablea

Question Posted / ganesh

3 Answers
8512 Views
Polaris, TCS, I also Faced
E-Mail Answers

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