Multi Table Insert

Step 1: Create table

create table mybuddy(name VARCHAR2(25),salary NUMBER);

Step 2: Create three more tables

CREATE table table1 as SELECT * FROM MYBUDDY where 1=2;

CREATE table table2 as SELECT * FROM MYBUDDY where 1=2;

CREATE table table3 as SELECT * FROM MYBUDDY where 1=2;

Step 3: Insert all -  in to table mybuddy

insert all INTO MYBUDDY(NAME,SALARY) VALUES ('Luke',7000)

           INTO MYBUDDY(NAME,SALARY) VALUES ('Henry',9500)

           INTO MYBUDDY(NAME,SALARY) VALUES ('Logan',3900)

           INTO MYBUDDY(NAME,SALARY) VALUES ('Benjamin',8000)

  SELECT * FROM dual;

Step 4: Multi Table Insert

Insert all

    into table1

    into table2

    into table3

select name,salary from mybuddy;