sqlplus "case when" statement

From: SDG <simong_at_explor.co.uk>
Date: Tue, 19 Sep 2000 10:28:09 +0100
Message-ID: <aiGx5.12$Ba1.7896_at_newsr1.u-net.net>


Hello,

[Quoted] Could anybody explain or provide information on how the case statement works [Quoted] when writting sqplus.

eg.

[Quoted] sum(case when resp_code in ('00','01') then [Quoted] decode(auth_type_code,'0210',amount_1,0) else 0 end )

Thanks in anticipation. Received on Tue Sep 19 2000 - 11:28:09 CEST

Original text of this message