Home » SQL & PL/SQL » SQL & PL/SQL » can we insert in multiple tables with one insert command
can we insert in multiple tables with one insert command [message #223615] Fri, 09 March 2007 15:35 Go to next message
AGARWALNIRU
Messages: 13
Registered: March 2007
Junior Member
hi

I am performing some rigourous data insertion
heres the snap shot of the psuedo code

Insert valid_email records and Timestamp into User and Application_User_Account tables
Where Email_address not in User table AND Account_id exists in Account AND Account_id exists in
Application_User_Account (accomplished with full outer join on User, Account, and
Application_User_Account tables)


from the valid_email i have to insert 3 diff cols in user table and other 3 in application_user_account

I would really appriciate your help..........thanks!!
Re: can we insert in multiple tables with one insert command [message #223618 is a reply to message #223615] Fri, 09 March 2007 15:45 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Check Insert statement in SQL reference guide for multitable insert clause i.e. INSERT ALL, INSERT FIRST.

Gints Plivna
http://www.gplivna.eu
Previous Topic: text formatting
Next Topic: Running this function resolved with error:ORA-31603...
Goto Forum:
  


Current Time: Wed Dec 07 02:48:45 CST 2016

Total time taken to generate the page: 0.10047 seconds