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 is acid property in database? : Sql dba
Can we have exception part in trigger ?
Is t sql a programming language?
what is ref cursor in pl/sql?
How do you explain an index?
How to select all records from the table?
Which data type is a composite type?
What are the types of join in sql?
how do you control the max size of a heap table? : Sql dba
What is the difference between inner join and natural join?
what is 'mysqladmin' in mysql? : Sql dba
----> There is a table T with two columns C1 and C2. The data is as below: C1 C2 1 4 2 5 3 6
Oracle (3253)
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)