Re: ">" in select-Statement

From: stupsnose <swetter_at_arcor.de>
Date: Thu, 21 Jul 2005 10:57:39 +0200
Message-ID: <42df6383$0$16824$9b4e6d93@newsread2.arcor-online.net>

stupsnose schrieb:
> Maxim Demenko schrieb:
>

>> stupsnose schrieb:
>>
>>> Hello!
>>>
>>> I wonder if i can use something like
>>> SELECT DECODE(a>b,0,1) FROM dual;
>>> to check if a is greater then b? Can someone help me please?
>>>
>>> Thank you!
>>> Stefan
>>
>>
>>
>> The simpliest approach would be to code that with a CASE - you can 
>> directly compare the values. If you must use decode however, it could be:
>>
>> Best regards
>>
>> Maxim

>
>
> Thank you. I don't know how to use CASE in an SELECT-Statement. Can you
> give me an example? Thanks!
>
> Stefan

I found an example. Thank you. I use Oracle8i, think CASE is not implemented there, is it?

Stefan Received on Thu Jul 21 2005 - 03:57:39 CDT