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

How to find the count of letter "L" in HELLO

7 Answers   HP,

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

How can you load multi line records? : aql loader

0 Answers  

Can a varchar be a primary key?

0 Answers  

What is a mutating table

5 Answers   TCS, Tech Mahindra,




State the advatage and disadvantage of Cursor's?

2 Answers  

What is sql select statement?

0 Answers  

What is view? Can we update view

0 Answers  

What is difference between mysql and postgresql?

0 Answers  

What is the difference between syntax error and runtime error?

0 Answers  

what are the features and advantages of object-oriented programming? : Sql dba

0 Answers  

can we call a procedure from a function?

9 Answers   Mind Tree,

For more SQL PLSQL Interview Questions Click Here
Categories