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 |
define primary key & secondary key?
How do you run a query?
How to call DDL statements from pl/sql?
What is the difference between delete, truncate and drop command?
what are the methods using performance tunning in sql and pl/sql
Is sql procedural language?
How can I change database name in sql?
what is the difference between sql and t-sql? : Transact sql
What are sql built in functions?
What is a primary key sql?
what is schema? : Sql dba
What is delete command in sql?
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)