Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: simple sql question - delete
"Ian" <estacey_at_chariot.net.ZZ> wrote in
news:42836e15$1_1_at_news.chariot.net.au:
> Hi,
> I have a number of tables which I wany to delete rows based on a
> condition. However, one or two of the tables may have multiple rows.
> eg DELETE TABLE1 TABLE2 TABLE3 TABLE4
> WHERE EMPID = 'ABCD1234'
> The problem is that table1 and table3 have multiple rows that match
> the where condition - which causes an error.
>
ERROR? What error? I don't see any error.
What make you conclude that multiple rows cause an error? Received on Thu May 12 2005 - 10:10:42 CDT