Interested to Buy Any Domain ? << Click Here >> for more details...
what are pl/sql collections?
- 4 Answers
- 32125 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 do I edit a trigger in sql developer?
How to look at the current sql*plus system settings?
What is the clause we need to add in function body to return variable?
Differentiate between sga and pga.
How many triggers can be applied on a table?
Explain the working of foreign key?
what are the limitations of identity column? : Transact sql
what is a field in a database ? : Sql dba
What is scope and visibility in PL/SQL?
What are the different set operators available in sql?
Differentiate between % rowtype and type record.
What is string data type in sql?
What is oracle and pl sql?
What is input buffer in sql*plus?
Write an sql query to select all records from the table?
