rowtype « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. rowtype
1.Use select command to fill value to rowtype variable
2.Define row type variable
3.Define rowtype and reference its column value
4.rowtype index by binary_integer
5.Use rowtype type value to query a table
6.Cursor and rowtype
7.For each row in the cursor
8.From Fields to Rows-Using %ROWTYPE
9.Insert table%rowtype to table




10.Rowtype variable
11.Select * into table%rowtype
12.Select data into rowtype variable
13.fetch sys_refcursor type variable to table%rowtype variable