Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Compare Longs

Compare Longs

From: Christopher Burke <craznar_at_hotmail.com>
Date: 9 Mar 2001 01:08:11 GMT
Message-ID: <905F7DB1Ccraznar@130.102.2.1>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US