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
What are the string functions in sql?
What are the differences between implicit and explicit cursors?
Explain cursor types?
What is sql mysql pl sql oracle?
What port does sql server use?
Which is better cte or subquery?
What is constant in pl sql?
What is the maximum number of rows in sql table?
Can we insert data in view?
How do I kill a query in postgresql?
What is foreign key sql?
Why having clause is used in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
Explain the purpose of %type and %rowtype data types with the example?
How do you create a db file?