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...
- 1 Answers
- 3725 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is embedded sql in db2?
What program will open a mdb file?
What is data type in database?
What is a column in a table?
Can we join tables without foreign key?
What is java sql connection?
List out the acid properties and explain?
Is sqlite thread safe?
What are the types of records?
How do you copy a table in sql?
What is prepared statement in sql?
what is the stuff function and how does it differ from the replace function? : Sql dba
Can we use ddl commands in pl sql?
What if we write return in procedure?
Why indexing is needed?
