Table of rowtype « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Table of rowtype
1.Use table of rowtype to define data type
2.table of employees%rowtype index by binary_integer
3.Declare an index-by table variable to hold the employee records in cursor
4.Close a nested table type
5.Loop through a table collection