OraFAQ Forum: SQL & PL/SQL » Update in two table by one update statement

Home » SQL & PL/SQL » SQL & PL/SQL » Update in two table by one update statement

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

Update in two table by one update statement [message #345720]

Thu, 04 September 2008 10:44

kapil.kaushish
Messages: 12
Registered: February 2007
Location: delhi

Junior Member

Hi Friends,

This is Kapil Kaushish from INDIA.
I want to update in two table by one sql statement. Please guide me how can i update this.

Regards,
Kapil Kaushish
kapil.kaushish@gmail.com

Report message to a moderator

Re: Update in two table by one update statement [message #345722 is a reply to message #345720]

Thu, 04 September 2008 10:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/t/88153/0/
Please read & follow posting guidelines as stated in URL above

You can NOT updated 2 tables in a single SQL statement.

Report message to a moderator

Previous Topic:	update statement
Next Topic:	filling in missing data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 09 20:15:40 CST 2024