what are pl/sql collections?
- 4 Answers
- 32399 Views
- JPMorgan Chase, Oracle, I also Faced
- E-Mail Answers
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
Can delete statement be rollbacked?
Does group by remove duplicates?
What is the best sql course?
Is inner join faster than left join?
how to use regular expression in pattern match conditions? : Sql dba
If a cursor is open, how can we find in a pl/sql block?
what are aggregate and scalar functions? : Sql dba
what are all the common sql function? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
What is the current version of postgresql?
what are the advantages of sql ? : Sql dba
what is dbms? : Sql dba
define sql insert statement ? : Sql dba
Can we rollback truncate?
Can we use distinct and group by together?
