OraFAQ Forum: SQL & PL/SQL » AND condition in DECODE

Home » SQL & PL/SQL » SQL & PL/SQL » AND condition in DECODE

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AND condition in DECODE [message #20243]

Wed, 08 May 2002 12:02

sri
Messages: 154
Registered: February 2000

Senior Member

How can I use and condition in decode.
I have the sitaution like this -

if (updt_typ = a) and (flmnt_id = y) then
1 else null

Report message to a moderator

Re: AND condition in DECODE [message #20245 is a reply to message #20243]

Wed, 08 May 2002 12:59

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

I would lean toward method1, but here are a couple of ways to do it:

sql>select updt_typ, flmnt_id,
  2         decode(updt_typ, 'a', decode(flmnt_id, 'y', 1, null), null) method1,
  3         decode(updt_typ || flmnt_id, 'ay', 1, null) method2
  4    from t;
 
U F   METHOD1   METHOD2
- - --------- ---------
a y         1         1
a n
b y
b n
x x

Report message to a moderator