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

Well no doubt it reads better in the "standard" way, though I asked it because it could be easier a shortcut if you need to write legacy code (c , java) that executes
sql statements built at runtime.....I remember something like "UPDATE table SET field +"
in DB2 and I wondered if there's something like this in Oracle... Francesco

Brian Peasland <peasland_at_usgs.gov> wrote in message 3AAF7737.CC704CB0_at_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 Thu Mar 15 2001 - 08:23:44 CST