Home » SQL & PL/SQL » Client Tools » insert into miultiple table (10.2.0.1)
insert into miultiple table [message #558442] Fri, 22 June 2012 04:41 Go to next message
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
Re: insert into miultiple table [message #558443 is a reply to message #558442] Fri, 22 June 2012 04:52 Go to previous message
Michel Cadot
Messages: 65389
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have a look at multi-table insert.

Regards
Michel
Previous Topic: SQLPLUS stops spool
Next Topic: problem related to background session
Goto Forum:
  


Current Time: Sat Feb 24 09:19:13 CST 2018

Total time taken to generate the page: 0.02182 seconds