What is PL collection?
What is PL collection? In this chapter, we will discuss the Collections in PL/SQL. A collection is an ordered group of elements having the same data type. Each element is identified by a unique subscript that represents its position in the collection. PL/SQL provides three collection types − Index-by tables or Associative array. What is Plsql table? Objects of type TABLE are called PL/SQL tables, which are modeled as (but not the same as) database tables. Like an array, a PL/SQL table is an ordered collection of elements of the same type. Each element has a unique index number that...