what are pl/sql collections?

Question Posted / dibya

4 Answers
30828 Views
JPMorgan Chase, Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what are pl/sql collections?..

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

what are pl/sql collections?..

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

what are pl/sql collections?..

Answer / praveenkumar

collection is set of ordered group of elements, all of the
same type.

Is This Answer Correct ?

15 Yes

2 No

what are pl/sql collections?..

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

Post New Answer