Interested to Buy Any Domain ? << Click Here >> for more details...
How collections are improve the performance?
- 1 Answers
- 4274 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 |
Can we use views in stored procedure?
Can you have more than one trigger on a table?
What are the methods of filing?
What is offset in sql query?
Can we insert data into view?
What is difference between pl and sql?
tell me about various levels of constraint. : Sql dba
What is the best free sql database?
what are the limitations of identity column? : Transact sql
Can %notfound return null after a fetch?
explain about mysql and its features. : Sql dba
Is there a way to automate sql execution from the command-line, batch job or shell script?
-
Oracle (3259) - 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)
