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

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL-sentence

Re: SQL-sentence

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Tue, 28 May 2002 20:47:13 +0200
Message-ID: <ad0jf9$b0p$1@crusher.de.colt.net> 





"Jon Ole Hedne" <johedne_at_online.no> schrieb im Newsbeitrag
news:4QPI8.6628$fG3.228341_at_news2.ulv.nextra.no...


> I want to list numbers in a column in this way:

>

> If Field > 0, Field - 5000, Else Field

>

> How can I solve this with a SQL-sentence?




Have a look at DECODE.



Regards,



Knut
Received on Tue May 28 2002 - 13:47:13 CDT












Original text of this message













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