with what ever knowledge I have, I think Coalesce statements are used in the Query part of the statement (select) and not in the where part, even if you can, the LHS should resolve to be a Column Name and you cannot use a literal like like "where 10 = 0".
if you are also using
Java then you could do most of the validations in the code itself before making the JDBC call
Originally posted by PraveenKumar Kannankutty:
WHERE ((coalesce(A_VALUE ,0) <> coalesce(?,0))
OR
(coalesce(B_VALUE ,0) <> coalesce(?,0))
OR
(coalesce(DATE_UPDATED,0) <> coalesce(?,0)))
[ October 25, 2005: Message edited by: RajaniKanth Bhargava ]