Use in parameter to pass value and insert value to a table

   

SQL>
SQL> create table t(
  2      n number
  3  )
  4  /

Table created.

SQL>
SQL> create or replace
  2    procedure insert_into_t( p_parm1 in number,  p_parm2 in number ) is
  3    begin
  4      insert into t values ( p_parm1 );
  5      insert into t values ( p_parm2 );
  6    end insert_into_t;
  7    /

Procedure created.

SQL>
SQL>
SQL> exec insert_into_t( p_parm1 => 101, p_parm2 => 102 );

PL/SQL procedure successfully completed.

SQL>
SQL> select * from t;

         N
----------
       101
       102

SQL>
SQL>
SQL> drop table t;

Table dropped.

SQL>
SQL>

Related examples in the same category

1.	Data insert in a procedure
2.	Insert data in procedure
3.	Insert value passed in by parameter to a table
4.	Insert value to a table after calculation
5.	Insert value to product and productcategory with stored procedure
6.	Insert value to table with for loop
7.	Insert a specified number of suppliers and products per supplier
8.	Insert 100000 rows into a table with for loop
9.	Loop through all to do a bulk insert
10.	An anonymous block program to write the record to a row
11.	This script demonstrates returning clause
12.	Bulk insert with insert ... select
13.	Hard code value and insert

Use in parameter to pass value and insert value to a table : Data Insert « PL SQL « Oracle PL / SQL

Related examples in the same category