OraFAQ Forum: Client Tools » insert into miultiple table

Home » Other » Client Tools » insert into miultiple table (10.2.0.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

insert into miultiple table [message #558442]

Fri, 22 June 2012 04:41

harshitaankur
Messages: 19
Registered: April 2012
Location: Delhi

Junior Member

Hello sir

I want to insert data into three table

my first table is

firstemp
having columns
1.EMPID
2.NAME
3.STATUS

second table is
secimp
have same columns as of first table

third table is

thirdimp

columns are same as of first andsecond

I want to insert in Firsttable if EMPid=EMP_1h
and insert in second table if empid=EMP_2u
and insert into third table if empid=emp_3p

Thankyou sir

Embarassed