Home » SQL & PL/SQL » SQL & PL/SQL » deleting,inserting,updating multiple tables
deleting,inserting,updating multiple tables [message #7562] Sun, 22 June 2003 01:35 Go to next message
shashi
Messages: 34
Registered: March 2001
Member
Is it possible to do a delete on multiple tables using a single statement. Something like delete from t1,t2,t3.

Similarly for insert and update also.

Thanks!

Report message to a moderator

Re: deleting,inserting,updating multiple tables [message #7617 is a reply to message #7562] Wed, 25 June 2003 05:00 Go to previous messageGo to next message
Chandru
Messages: 12
Registered: July 2000
Junior Member
No these three allow you to handle only one table at a time.

HTH
Chandru

Report message to a moderator

Re: deleting,inserting,updating multiple tables [message #7622 is a reply to message #7562] Wed, 25 June 2003 06:12 Go to previous messageGo to next message
jigar
Messages: 74
Registered: July 2002
Member
If possible, define dependancy like cascade delete, this will serve your requirement

Report message to a moderator

Re: deleting,inserting,updating multiple tables [message #7640 is a reply to message #7562] Thu, 26 June 2003 04:04 Go to previous messageGo to next message
Gilbey
Messages: 87
Registered: March 2002
Member
Use trigger

Report message to a moderator

Re: deleting,inserting,updating multiple tables [message #7660 is a reply to message #7617] Fri, 27 June 2003 10:52 Go to previous message
shashi
Messages: 34
Registered: March 2001
Member
Actually this was one of the questions I came accross , so wanted to know the answer.

Thank you all.

Report message to a moderator

Previous Topic: 'DROP USER CASCADE' - HOW IT WORKS?
Next Topic: diff between TRUNCATE & DELETE
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 06:15:35 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.