Column%type parameter : Type « PL SQL « Oracle PL / SQL






Column%type parameter

  
SQL>
SQL> create table myTable (
  2    col varchar2(10)
  3   );

Table created.

SQL>
SQL>
SQL>
SQL>
SQL> create or replace procedure ADD_NUM_ROW(p_col myTable.COL%TYPE) is
  2    begin
  3        insert into myTable values (p_col);
  4    end;
  5   /

Procedure created.

SQL>
SQL>
SQL> show errors;
No errors.
SQL>
SQL>
SQL> drop table myTable;

Table dropped.

SQL>
SQL>
SQL>

   
    
  








Related examples in the same category

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.reference table data with tableName.columnName%type
7.Add row to table with tableName.columnName%type