Insert value passed in by parameter to a table

    

SQL> CREATE TABLE myTable2 (
  2      a INTEGER,
  3      b CHAR(10)
  4  );

Table created.

SQL>
SQL> CREATE or replace PROCEDURE addtuple1(i IN NUMBER) AS
  2  BEGIN
  3      INSERT INTO myTable2 VALUES(i, 'xxx');
  4  END addtuple1;
  5  /

Procedure created.

SQL>
SQL> drop table myTable2;

Table dropped.

SQL>

Related examples in the same category

1.	Use in parameter to pass value and insert value to a table
2.	Data insert in a procedure
3.	Insert data in procedure
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

Insert value passed in by parameter to a table : Data Insert « PL SQL « Oracle PL / SQL

Related examples in the same category