RE: ** is there PL/SQL for case

[Igor Neyman]

RTFM on DECODE:   DECODE(state, 1, ‘CA’, 2, ‘OR’, 3, ‘WA’, 4, ‘AR’)   Igor Neyman, OCP DBA [EMAIL PROTECTED]     -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of A Joshi Sent: Thursday, August 07, 2003 3:24 PM To: Multiple recipients of list ORACLE-L Subject: ** is there PL/SQL for case   Hi,   Is there a statement in pl/SQL like case or is if elsif the only way. Meaning if I need to transalate state depending on input number as follows :   1 - CA 2 - OR 3 - WA 4 - AR   Can I have one statement like case 'state# :   1: state := 'CA' 2: state := 'OR'   etc.   or do i have to do :   IF state# = 1 THEN   state := 'CA'; ELSIF state# = 2 THEN   state := 'OR';   etc   Thank You.     Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software