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 you write a subquery?
How can we store rows in PL/SQL using array?
How many joins in sql?
what is a unique key ? : Sql dba
Mention what is the use of function "module procedure" in pl/sql?
What is pl sql package?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is oracel sql developer written in java?
Name three sql operations that perform a sort.
What is the left table in sql?
what are the differences between require and include, include_once and require_once? : Sql dba
What is a unique constraint?
Is not null in sql?
What is the purpose of using pl/sql?
Is mariadb a nosql database?