OraFAQ Forum: SQL & PL/SQL » DECODE -- pls help!

Home » SQL & PL/SQL » SQL & PL/SQL » DECODE -- pls help!

Fri, 07 November 2003 11:57

Ivory Williams
Messages: 13
Registered: October 2001

Junior Member

I would like to use more than one parameter in a DECODE statement.

DECODE(deduct_bdca_code,'def' *** or ***'ghi',deduct_empl_amt,0)

Fri, 07 November 2003 12:02

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

DECODE(deduct_bdca_code
,      'def',deduct_empl_amt
,      'ghi',deduct_empl_amt
,      0)

HTH,

A.

Sat, 08 November 2003 17:49

William Robertson
Messages: 1643
Registered: August 2003
Location: London, UK

Senior Member

Or you could try CASE.

Previous Topic:	Between Dates
Next Topic:	error 01034 & 27101

Goto Forum:

]

Current Time: Tue Apr 23 16:19:45 CDT 2024