Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Case when with 2 conditions

Case when with 2 conditions

From: Carlos Antonio <carlosantoniovazquez_at_gmail.com>
Date: 2 Jun 2006 06:47:19 -0700
Message-ID: <1149256039.122215.145200@h76g2000cwa.googlegroups.com>


Hello,

How can I use the case when statement, but with 2 conditions?

is it like ...

    case

            when (field1 = 'A' and Field2 = 'B') then 'C'
             else 'Z'

    end as whatever_result

...???

Any help will be appreciated Received on Fri Jun 02 2006 - 08:47:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US