Type « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Type
1.Declare scalars based on the datatype of a previously declared variable
2.rowtype and type
3.Select only one row for column type variable
4.Creating a procedure and call it
5.Passing %TYPE and %ROWTYPE as Parameters
6.Column%type parameter
7.reference table data with tableName.columnName%type
8.Add row to table with tableName.columnName%type