Re: Can you use "If..Then" logic in SQL?

Hi,

    When people post in Oracle newsgroups they should expect Oracle specific responses since some newsreaders don't show which newsgroups have been posted to.

regards

Jerry Gitomer

fungi wrote in message ...
>I was under the impression that was an Oracle-only SQL92 code, and not
>available anywhere else....
>
>fungi
>
>
>Adrian Biffen <adrian_biffen_at_playstation.sony.com> wrote in message
>news:375C0213.7DFA967A_at_playstation.sony.com...
>> You can also use the decode function:
>> select decode(column_a, condition, value if true, value if false)
>> from table_1;
>>
>> Cheers
>> Adrian
>>
>>
>> Inna Minder wrote:
>>
>> > This is not Exactly correct. You can use "Case Then Else" statment.
>> >
>> > SELECT 'Something' =
>> > CASE type
>> > WHEN 'One' THEN '20'
>> > WHEN 'Two' THEN '21'
>> > WHEN 'Three' THEN '22'
>> > WHEN 'Four' THEN '23'
>> > WHEN 'Five' THEN '24'
>> > ELSE '100'
>> > END,
>> > SomethingElse, SomethingElse2
>> > FROM table
>> > WHERE .....
>> > Thank's Anton Rakushkin
>> >
>> > David Russell <dbruce_at_kreative.net> wrote in message
>> > news:3741f9fb.19123628_at_news...
>> > >
>> > > SQL is not "procedural"... that's why PL/SQL was developed. You can
>> > > use some of the report writing features to get nested reports; but,
>> > > for true if/then/else logic go elsewhere: PL/SQL, 3GL, Java...
>> > >
>> > > David Russell
>> > >
>>
>
>
Received on Tue Jun 08 1999 - 07:42:42 CDT