what are pl/sql collections?
Answer Posted / 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 View All Answers
what are the limitations of identity column? : Transact sql
how to enter characters as hex numbers? : Sql dba
What is dense_rank?
What are the uses of merge?
What is crud diagram?
How do temporal tables work?
how to enter numeric values as hex numbers? : Sql dba
How do I save a stored procedure?
What is union, minus and interact commands?
discuss about myisam index statistics collection. : Sql dba
how to calculate the difference between two dates? : Sql dba
Is sql pronounced sequel or sql?
Can a primary key be a foreign key?
Why are aggregate functions called so?
How do you create a unique index?