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

Home -> Community -> Usenet -> c.d.o.server -> Update setting -ve number to 0

Update setting -ve number to 0

From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 9 Oct 2006 16:36:32 +0100
Message-ID: <MPG.1f947ba66a45c49998a304@news.individual.net>


Oracle 9iR2

In the following:

update mytable
set col = col-20
where id=1;

Brain has gone blank - want to set col to zero if the result of col-20 < 0

Found function "least" which enables seeting a value to the lowest in a list - I was wondering if there was a "most" function?

Cannot believe I cannot think how to do this!

-- 
jeremy
Received on Mon Oct 09 2006 - 10:36:32 CDT

Original text of this message

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