Home » SQL & PL/SQL » SQL & PL/SQL » Is it possibe to Update 2 or more table in single query ? (Oracle 9i)
Is it possibe to Update 2 or more table in single query ? [message #330323] Sun, 29 June 2008 09:39 Go to next message
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]
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
I wonder if is it possibe to Update 2 or more table in single query ?
NOT possible.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No, it is not possible.
Why? Because it is not in SQL.

Regards
Michel
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 Go to previous messageGo to next message
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.
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Because it is not in SQL.

Regards
Michel
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 Go to previous message
agassis
Messages: 4
Registered: June 2008
Location: UK
Junior Member

Thanks Michel, I can understand.
Previous Topic: Statements within variable,
Next Topic: union
Goto Forum:
  


Current Time: Wed Dec 07 10:52:55 CST 2016

Total time taken to generate the page: 0.07919 seconds