Re: sqlplus "case when" statement
From: <martin_suttrup_at_my-deja.com>
Date: Tue, 19 Sep 2000 15:04:11 GMT
Message-ID: <8q7v8r$m1i$1_at_nnrp1.deja.com>
Date: Tue, 19 Sep 2000 15:04:11 GMT
Message-ID: <8q7v8r$m1i$1_at_nnrp1.deja.com>
In article <aiGx5.12$Ba1.7896_at_newsr1.u-net.net>,
"SDG" <simong_at_explor.co.uk> wrote:
> Hello,
>
> Could anybody explain or provide information on how the case statement
works
> when writting sqplus.
>
> eg.
>
> sum(case when resp_code in ('00','01') then
> decode(auth_type_code,'0210',amount_1,0) else 0 end )
>
> Thanks in anticipation.
>
Hi
I'm not sure, but I think 'case' isn't supported by Oracle. It is a Transact SQL Statement (used with SQL-Server) and can be converted by the use of 'decode' or by writing your own stored procedures.
Martin
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Tue Sep 19 2000 - 17:04:11 CEST