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 / 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 |
What are the types of variable use in pl sql?
Which sorts rows in sql?
What are the disadvantages of not performing database normalization?
what are the performance and scalability characteristics of mysql? : Sql dba
What is the primary use of normalization?
What is java sql driver?
How do I run a script in sql developer?
What is your daily office routine?
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
Can we use having without group by in sql?
what is 'mysqlshow'? : Sql dba
what is constraining table?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)