Home » SQL & PL/SQL » SQL & PL/SQL » 1 statement to delete , update 2 tables
icon14.gif  1 statement to delete , update 2 tables [message #211619] Sat, 30 December 2006 00:25 Go to next message
josh_snehal
Messages: 15
Registered: May 2006
Location: BANGALORE
Junior Member
Hi Buddy,

Wish you a Happy & prosporous New Year.
Have some interesting questions , if someone can answer with explanation that will be great.

1. Can we delete from 2 tables using single delete command ?
2. Can we update 2 tables at a time using 1 update statement ?


I guess answer for first is NO , but not sure if using In-Line Updatable views if this can be made possible.

Example queries if any can be of good help.


Thanks
Snehal

[Updated on: Sat, 30 December 2006 00:26]

Report message to a moderator

icon2.gif  Re: 1 statement to delete , update 2 tables [message #211637 is a reply to message #211619] Sat, 30 December 2006 04:12 Go to previous messageGo to next message
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
as anacedent would say

the homework tutor is on the second left in the ground floor!!!
Re: 1 statement to delete , update 2 tables [message #211728 is a reply to message #211619] Mon, 01 January 2007 22:49 Go to previous message
nabbu
Messages: 5
Registered: December 2006
Junior Member
Actually I am searching for the similar solution for
update.
If you find one please kindly send me reply.
happy new year to you.
Previous Topic: Seperating a Value from a set of comma seperated values
Next Topic: pl/sql code
Goto Forum:
  


Current Time: Wed Feb 19 16:34:33 CST 2025