Re: ">" in select-Statement

On 2005-07-21, stupsnose <swetter_at_arcor.de> wrote:
> 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?

8i's SQL knows case when..end.

But not within PL/SQL.

9i onwards does have it in PL/SQL also.

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/