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 |
How many sql are there?
What are the packages in pl sql?
How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?
How to perform a loop through all tables in pl/sql?
What is query execution plan in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is pls integer?
Inline the values in PL/SQL, what does it mean.?
How is pl sql different from sql?
When sql appeared?
What is java sql driver?
What is exit statement?