How collections are improve the performance?
- 1 Answers
- 3495 Views
- Polaris, I also Faced
- E-Mail Answers
Answer / kesava
COLLECTION:
Collection contains number of user defined types which is
stored number of data items in Single unit.
Why introduce Collection:
--->When ever we are using cursor memory area control does not get it back from Active set Area.
=====>when ever we are using Collection we are operating
element and also we are moving forward and reverse directions with in memory are using Collection
collection Types:
index by Table
Nested Table
Varray
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the difference between sql, mysql and sql server?
What are the types of triggers ?
26 Answers Aspire, BirlaSoft, TCS,
How exception handling is done in advance pl/sql?
How can a pl sql block be executed?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is cartesian join in sql?
What is the use of triggers?
Can we insert data into view?
Does sql full backup truncate logs?
what is “go” in t-sql? : Transact sql
How do I quit sql?
What is sql lookup?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
