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>
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