Alexander Mueller wrote:
> Mark C. Stock schrieb:
>
>> "Alexander Mueller" <millerax_at_hotmail.com> wrote:
>
>
>>> how can i use Decode if I want to evaluate an boolean expression?
>>> I want to convert an Access-SQL-Statement using IIF:
>>>
>>> IIf (Val > 100, ID, 9999) As ID
>>>
>>> How can I check if Val is bigger then 100 with Decode,
>>> my pseudo code looks like:
>>>
>>> Decode (Val > 100, true, ID, 9999) As ID
>>>
>>> but what's the equivalent for 'true' in PL/SQL?
>>>
>>> Mfg,
>>> Alex
>>
>>
>> CASE expression (depending on your DB version)
>>
>> otherwise, use a DECODE on a SIGN expression (returns -1, 0, or 1 and
>> can be used to kludge if-then-else logic)
>
>
> Hi Mark
>
> We have 8i, I think that is pre-CASE, but SIGN does work.
> I noticed that SIGN doesn't accept expression using '>' or '<',
> like SIGN (INT_VALUE < 0), but instead of writing
> column_name < 100 one can also write column_name - 100 and test
> if it is bigger 0 so i can change the code now using DECODE with SIGN
> Thanks for your response, helps me to fix a lot code.
>
> Mfg,
> Alex
CASE works in 8i. You just need to use it in the form of Native Dynamic SQL.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Jan 25 2006 - 10:53:08 CST
