Interested to Buy Any Domain ? << Click Here >> for more details...
How collections are improve the performance?
- 1 Answers
- 4367 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 |
when MSQL8.0 is in market
What is indexes?
How to prepare for oracle pl sql certification?
Is there any restriction on the use of union in embedded sql?
What are triggers, and when would you use them?
How to add, remove, modify users using sql?
IF i write before / after insert / update trigger and i do rollback what will happen?
How does cross join work in sql?
What are pl/sql packages?
What trigger means?
What does pl sql developer do?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
-
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)
