Data insert in a procedure : Data Insert « PL SQL « Oracle PL / SQL

Data insert in a procedure

   


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

Related examples in the same category

1.	Use in parameter to pass value and insert value to a table
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