View Single Post
Old 01-29-2013, 10:09 PM   PM User | #2
Old Pedant
Supreme Master coder!

 
Old Pedant's Avatar
 
Join Date: Feb 2009
Posts: 23,200
Thanks: 59
Thanked 3,996 Times in 3,965 Posts
Old Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to allOld Pedant is a name known to all
If it throws an error, then it's not conformant with ANSI SQL, at all.

ANSI says a DELETE that affects zero records is never an error.

I would be truly surprised if Oracle went against ANSI on something this fundamental.

*********

If you are only looking to see how many records were deleted, most DB interfaces will give you that information.
__________________
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
Old Pedant is offline   Reply With Quote