Use a stored procedure to insert data to a table : Insert « Stored Procedure Function « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Stored Procedure Function
  3. Insert

Use a stored procedure to insert data to a table

  
SQL>
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>  select * from t;

no rows selected

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> drop table t;

Table dropped.








Related examples in the same category

1.Insert data into a table in a stored procedure
2.Use two insert statements in a procedure
3.Roll back data inserted in a procedure
4.Use stored procedure to insert value to a table and use select statement to check the result
5.Adjust salary with pl/sql
6.This procedure will insert a new book into the book table.