Use stored procedure to insert value to a table and use select statement to check the result : Insert « Stored Procedure Function « Oracle PL / SQL






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

Use stored procedure to insert value to a table and use select statement to check the result

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

Table created.

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

Procedure created.

SQL>
SQL>
SQL>  select * from t;

no rows selected

SQL>
SQL>  exec insert_into_t( p_parm => 100 );

PL/SQL procedure successfully completed.

SQL>
SQL> select * from t;

         N
----------
       100

SQL>
SQL> drop table t;

Table dropped.

SQL>
SQL>
SQL>








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 a stored procedure to insert data to a table
5.Adjust salary with pl/sql
6.This procedure will insert a new book into the book table.