OraFAQ Forum: SQL & PL/SQL » Is it possibe to Update 2 or more table in single query ?

Home » SQL & PL/SQL » SQL & PL/SQL » Is it possibe to Update 2 or more table in single query ? (Oracle 9i)

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

Is it possibe to Update 2 or more table in single query ? [message #330323]

Sun, 29 June 2008 09:39

agassis
Messages: 4
Registered: June 2008
Location: UK

Junior Member

I wonder if is it possibe to Update 2 or more table in single query ?

Since we know that it is possible to query 2 or more tables and update a single table using JOIN statement in single query

So why not updating 2 or more table is possible in a single sql query [without using multiple query or without using pl/sql]

Report message to a moderator

Re: Is it possibe to Update 2 or more table in single query ? [message #330324 is a reply to message #330323]

Sun, 29 June 2008 09:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I wonder if is it possibe to Update 2 or more table in single query ?
NOT possible.

Report message to a moderator

Re: Is it possibe to Update 2 or more table in single query ? [message #330325 is a reply to message #330323]

Sun, 29 June 2008 09:45

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, it is not possible.
Why? Because it is not in SQL.

Regards
Michel

Report message to a moderator

Re: Is it possibe to Update 2 or more table in single query ? [message #330473 is a reply to message #330325]

Mon, 30 June 2008 04:31

agassis
Messages: 4
Registered: June 2008
Location: UK

Junior Member

Michel, can you give little more explanation for why it is not possible in SQL query please.

Report message to a moderator

Re: Is it possibe to Update 2 or more table in single query ? [message #330478 is a reply to message #330473]

Mon, 30 June 2008 04:50

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Because it is not in SQL.

Regards
Michel

Report message to a moderator

Re: Is it possibe to Update 2 or more table in single query ? [message #330493 is a reply to message #330478]

Mon, 30 June 2008 05:12

agassis
Messages: 4
Registered: June 2008
Location: UK

Junior Member

Thanks Michel, I can understand.

Report message to a moderator

Previous Topic:	Statements within variable,
Next Topic:	union

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 10 21:41:07 CDT 2025