Home » SQL & PL/SQL » SQL & PL/SQL » Delete statement...
Delete statement... [message #23067] Fri, 15 November 2002 15:32 Go to next message
raman
Messages: 66
Registered: February 2000
Member
Is it possible, with a single delete statement can I remove the records from Parent and Child table at once?

Please let me know as soon as possible....

-Raman

Report message to a moderator

Re: Delete statement... [message #23068 is a reply to message #23067] Fri, 15 November 2002 16:23 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Not directly through the statement, but certainly indirectly through either referential integrity (ON DELETE CASCADE) or triggers.

Report message to a moderator

Previous Topic: Using PL/SQL table and flat file
Next Topic: Using a Union and order by with lowered cases
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 06 11:09:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.