what are pl/sql collections?
Answers were Sorted based on User's Feedback
Answer / pradeep
A collection is an ordered group of elements, all of the
same type. It is a general concept that encompasses lists,
arrays, and other familiar datatypes. Each element has a
unique subscript that determines its position in the collection.
PL/SQL offers these collection types:
* Index-by tables,
* Nested tables
* Varrays
Is This Answer Correct ? | 50 Yes | 2 No |
Answer / hannan oca
collection of similar datatypes or group of same datatypes
are called collections.Basically they are 3 types
1.Index-by tables,
2.Nested tables
3.Varrays
collection of different datatypes are known as Records.
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / praveenkumar
collection is set of ordered group of elements, all of the
same type.
Is This Answer Correct ? | 15 Yes | 2 No |
Answer / debanjan rudra
pl/sql collections are temporary table types which helps
the programmer to "temporary" manipulate data comprising
more than 1 row (i.e. not scalar).
Eg. CREATE OR REPLACE TAB AS TABLE OF VARCHAR2(100) INDEX
BY PLS_INTEGER;
In the above example "TAB" is a collection which shall be
used to temporarily store more than 1 varchar2 records.
Is This Answer Correct ? | 8 Yes | 3 No |
What are functions in sql?
What is a 'instead of trigger'?
a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.
How does cross join work in sql?
What is difference between mysql and postgresql?
what are wild cards used in database for pattern matching ? : Sql dba
what are integrity rules?
can sql servers linked to other servers like oracle? : Sql dba
What is normalisation and its types?
What are the data types allowed in a table?
can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?
What is type and rowtype in pl sql?