Add row to table with tableName.columnName%type

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

Table created.

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

Procedure created.

SQL>
SQL>
SQL> drop table myTable;

Table dropped.

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.	Column%type parameter
7.	reference table data with tableName.columnName%type

Add row to table with tableName.columnName%type : Type « PL SQL « Oracle PL / SQL

Related examples in the same category