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

what are different types of collation sensitivity? : Sql dba

0 Answers  

What are synonyms in sql?

0 Answers  

How do I know if I have sql express or standard?

0 Answers  

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

Types of indexes. What is the default key created when a primary key is created in a table ?

5 Answers   TCS,




What is a transaction?

5 Answers  

What is rowid in sql?

0 Answers  

How to rename a table?

0 Answers  

What is cursor explain with example?

0 Answers  

Which data type is a composite type?

0 Answers  

Can a foreign key be null?

0 Answers  

use of IN/ANY/ALL

5 Answers   Ramco,

For more SQL PLSQL Interview Questions Click Here
Categories