Re: how to do in Oracle field-- or field++

From: Brian Peasland <peasland_at_usgs.gov>
Date: Wed, 14 Mar 2001 13:50:47 GMT
Message-ID: <3AAF7737.CC704CB0@usgs.gov>

How about:

UPDATE some_table SET some_field = some_field+1; COMMIT; It works the old fashioned way!

HTH,
Brian

Francesco Marchioni wrote:
>
> Hello,
> I'd like to know if there are any shortcuts in
> oracle to do an UPDATE of a field by 1,
>
> like in C
> x++ or x--
>
> thanks
> Francesco

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================

Received on Wed Mar 14 2001 - 07:50:47 CST