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
How do I view a sql database?
What are field types?
Can we use join in subquery?
What is posting?
What does pl sql developer do?
What are tables and fields in the database?
Why select is used in sql?
Explain what is a database?
How does join work in sql?
Can a view be mutating? If yes, then how?
What is sql mysql pl sql oracle?
Explain the difference in execution of triggers and stored procedures?
How to add a column ‘salary’ to a table employee_details?
What is the usage of nvl function?
How subquery works in sql?