| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: question on delete statement
Originally posted by Fabio
> How could I know if I'm deleting records from A table or B table
> or both ?
>
See "key preserved" explanation in my previous response.
Originally posted by Fabio
> Is there some syntax to specify the table I want delete records from?
>
Yes:
delete A
where A.f1 in (select B.f1 from B where ...)
and ...
-- Posted via http://dbforums.comReceived on Fri Jun 20 2003 - 11:05:45 CDT
 |
 |