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...
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
Is keyword pl sql?
What is write ahead logging in sql server?
Are stored procedures faster than queries?
How does sql developer connect to oracle database?
What is difference between inner join and self join?
what is the difference between truncate and delete statement? : Transact sql
what is 'trigger' in sql? : Sql dba
What is rowid in sql?
What are sql procedures?
What is meant by temporal data?
What is the difference between a database and a relational database?
What is rownum in sql?
What is the difference between jpql and sql?
What is a design view?
Is the primary key an index?