Category Archives: PL/SQL


PL/SQL Collection Data Types

A collection is an ordered group of elements, all of the same 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 Nested table Variable-size array or Varray   VARRAY Varrays hold a fixed-sized sequential collection of elements .. All varrays… Read More »

What is PL/SQL Records Data Types

A PL/SQL record is a composite data structure that is a group of related data stored in fields.  Records are composed of a group of fields, similar to the columns in a row . The %ROWTYPE attribute lets you declare a PL/SQL recordthat represents a row in a database table, without listing all the columns. PLSQL handle three type of Records 1)User- Define… Read More »