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...
- 1 Answers
- 4382 Views
- HCL, Satyam, I also Faced
- E-Mail Answers
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 |
How to call a javascript function from pl sql?
Does truncate free space?
What is the usage of nvl function?
What is not null in sql?
What is pl sql architecture?
what is union, minus and interact commands? : Sql dba
When should I use nosql database?
What are different types of triggers?
Can we create non-clustured index on a clustered index ?
What does seeding a database mean?
What are the parts of a sql statement?
what is primary key? : Sql dba
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
