Interested to Buy Any Domain ? << Click Here >> for more details...
what are pl/sql collections?
- 4 Answers
- 32267 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 you sum a count in sql?
What is sqlite used for?
What is the difference between delete and truncate commands?
What is interval partition?
Why indexing is needed?
What is the difference between microsoft access and sql?
What is faster join or subquery?
What is the use of non clustered index?
what is the use of double ampersand (&&) in sql queries?
How do you drop a trigger?
Why do we create views in sql?
What is equi join in sql?
how to select unique records from a table? : Sql dba
What is meant by truncate in sql?
Does sap use sql?
