OraFAQ Forum: SQL & PL/SQL » can we insert in multiple tables with one insert command

Home » SQL & PL/SQL » SQL & PL/SQL » can we insert in multiple tables with one insert command

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

can we insert in multiple tables with one insert command [message #223615]

Fri, 09 March 2007 15:35

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!!

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	text formatting
Next Topic:	Running this function resolved with error:ORA-31603...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 08:19:18 CST 2024