Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Compare Longs
I need to compare the database value of a LONG with a new value.
Is there any way of telling if they are different, as I only want to update the row if they are different.
As in...
update table
set field1=new_field1, longfield=new_longfield, dirty='Y' where field1<>new_field1 and longfield<>new_longfield;Received on Thu Mar 08 2001 - 19:08:11 CST
![]() |
![]() |