data Insertion PLSQL

         PLSQL code to insert values in table

In this tutorial i will show you how  to insert data in a table by taking input from the user.

  declare
   number1 number;
   number2 varchar2(20);
    procedure insert_in(value in number, value1 in varchar2)
    as
    begin
   insert into test1 values(value,value1); --test1 is the table name
   end;
     
   begin
     number1 := &Enter_id;
     number2 := '&Enter_Name';
     insert_in(number1,number2);
   end;