Home » SQL & PL/SQL » SQL & PL/SQL » updating two tables (merged)
updating two tables (merged) [message #381451] Sat, 17 January 2009 01:15 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Can we update two tables at a time using one update statement?
If it is possible give me one example?Please help me?
Re: updatating two tables [message #381457 is a reply to message #381451] Sat, 17 January 2009 01:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In SQL, no.

Regards
Michel
updating two tables [message #381508 is a reply to message #381451] Sat, 17 January 2009 08:30 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Can we update two tables using one update statement in pl/sql block?If it is posssible please give me one example?
Re: updating two tables [message #381520 is a reply to message #381508] Sat, 17 January 2009 09:18 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Same answer.

Regards
Michel
Previous Topic: maximum size of a row
Next Topic: Predefined Exceptions
Goto Forum:
  


Current Time: Mon Dec 05 15:21:39 CST 2016

Total time taken to generate the page: 0.15488 seconds