Interested to Buy Any Domain ? << Click Here >> for more details...
How collections are improve the performance?
- 1 Answers
- 4211 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 difference between table and view?
How many types of keys are there in sql?
What are the types of index in sql?
What are the possible values for the boolean data field?
what is the use of set statement in tsql? : Transact sql
how can you create an empty table from an existing table? : Sql dba
Why do we need cursors in pl sql?
What is nosql db?
describe transaction-safe table types in mysql : sql dba
What is the difference between delete, truncate and drop command?
What are the different ways to optimize a sql query?
who introduced sql?
-
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)
