Re: help with decode

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Wed, 03 Aug 2005 21:00:30 +0200
Message-ID: <dcr3rv$i86$2@news4.zwoll1.ov.home.nl>

Noons wrote:
> soup_or_power_at_yahoo.com apparently said,on my timestamp of 4/08/2005
> 12:28 AM:
>

>> sybrandb_at_yahoo.com wrote:
>>
>>> The syntax is
>>> <string expression>||<string expression>
>>>
>>> No comma's.
>>
>>
>>
>> So the following are the same?
>>
>> SELECT (DECODE(a1, 'b1', a2, 'b2')) from A
>>
>> SELECT (DECODE(a1, 'b1 || a2, 'b2')) from A

>
>
> No. the first is the syntax for a decode with 4 terms.
> the second is the syntax for a decode with three terms
> in which the second term is a concatenation, following
> the model Sybrand showed you above.

The second is an error... I miss a quote, and thus it is not a concatenation.

-- 
Regards,
Frank van Bortel

Received on Wed Aug 03 2005 - 14:00:30 CDT