what are pl/sql collections?
- 4 Answers
- 31174 Views
- JPMorgan Chase, Oracle, I also Faced
- E-Mail Answers
Answer Posted / pradeep
A collection is an ordered group of elements, all of the
same type. It is a general concept that encompasses lists,
arrays, and other familiar datatypes. Each element has a
unique subscript that determines its position in the collection.
PL/SQL offers these collection types:
* Index-by tables,
* Nested tables
* Varrays
| Is This Answer Correct ? | 50 Yes | 2 No |
Post New Answer View All Answers
What is sql server and ase?
How many types of indexes are there in sql?
What is meant by truncate in sql?
What is the syntax and use of the coalesce function?
What is union and union all keyword in sql?
Does truncate need commit?
Are subqueries faster than joins?
How to get list of all tables from a database?
how to fetch common records from two tables? : Sql dba
What is an oracle stored procedure?
What is the difference between functions, procedures, and packages in pl/sql?
Can I join the same table twice?
What is the difference between unique and primary key constraints?
what are the properties and different types of sub-queries? : Sql dba
What is a scalar value in sql?
