Main diff between varray and nested tablea

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 to combine two stored procedures in sql?

0 Answers  


Is sql workbench free?

0 Answers  


What are the different types of dbmss?

0 Answers  


What is spool?

0 Answers  


What is the difference between CHAR and VARCHAR2? If VARCHAR2 serves the uses of CHAR why CHAR is still used and not been discarded yet?

9 Answers   Oracle,






what is csv? : Sql dba

0 Answers  


What are the blocks in stored procedure?

6 Answers   Microsoft,


What is the maximum size of sqlite database?

0 Answers  


What is cursor in pl sql with examples?

0 Answers  


what are the methods using performance tunning in sql and pl/sql

2 Answers  


What do you mean by stored procedures? How do we use it?

0 Answers  


How to delete same emp id in sql query for exmaple in emp table emp id, empname, emp address. for example emp id =5, repeated in two times in rows same id how to delete same empid please any one of the write query send in my id

8 Answers   CGCI,


Categories