Interested to Buy Any Domain ? << Click Here >> for more details...
what are pl/sql collections?
- 4 Answers
- 32055 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
How many times can we commit in a loop?
What is a schema? How is it useful in sql servers?
What is query syntax?
What is meant by cursor in sql?
How delete all records from table in sql?
What do you mean by query optimization?
What are the parts of a basic sql query?
How do I restart sql?
What is the difference between python and sql?
What are different types of tables in sql?
What are the sql versions?
What is the difference between subquery and correlated query?
what is denormalization. : Sql dba
What is Materialized View? In What Scenario we Use Materialized View?
What is a scalar value in sql?
