Interested to Buy Any Domain ? << Click Here >> for more details...
How collections are improve the performance?
- 1 Answers
- 4373 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 |
Does execute immediate commit?
What is an exception in pl/sql?
What is Collation Sensitivity ? What are the various type ?
how to retrieve the top 2 salaried persons from a database?
Does db2 use sql?
In a package if we have 10 procedures or functions,How to know which will execute first?
What are the differences between in and exists clause?
What is delimiter in pl sql?
What is the difference between anonymous block and named block or stored procedure?
What do we need to check in database testing?
What is rownum and rowid?
How can we optimize a sql query?
-
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)
