1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between varray and table data
type..please expalain with some examples...

under what situation you will go for varray..instead of
index by table...

Question Posted / sweetsarao


what is the difference between varray and table data type..please expalain with some examples... ..

Answer / anil kumar jaiswal

the major difference you can say here is bounding.
varray is bounded but index by table is not bounded.
means in varray you can mention the limit but in index by table you cannot.

if you got with performance varray is more effective and faster than index by table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Is sql a programming?

0 Answers  

What are the Restrictions on Cursor Variables?

2 Answers  

Whate is use of MOD function in pl/sql.

3 Answers   Oracle,

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

What are the different dml commands in sql?

0 Answers  




what the meaning of sql

8 Answers  

How many row comparison operators are used while working with a subquery?

0 Answers  

How to count the no of records of a table without using COUNT function?

11 Answers   TCS, Tesco,

Explain 3 basic parts of a trigger.

0 Answers  

What is different between union and minus?

7 Answers   Accenture, TCS,

What is duration in sql profiler trace?

0 Answers  

What are wait events. Describe the wait event tables.

1 Answers   CTS,

For more SQL PLSQL Interview Questions Click Here
Categories