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 »

Bulk Collect and Bulk Bind

Retrieve many row in single fetch and improve the speed of data retrieval by less context switch. Oracle server used two engine to run PL/SQL block and subprogram. 1) The PL/SQL   runtime engine , which  run  all procedural line of code but passes the SQL statement to the SQL engine. 2)The SQL engine parse and executes the SQL… Read More »