RE: Decode in PL/Sql

From: FOX, Simon <Simon.FOX_at_sema.co.uk>
Date: Thu, 17 May 2001 02:46:44 -0700
Message-ID: <F001.00305F03.20010517023116@fatcity.com>

Feuerstein recommends replacing with IF statements. Page 517 Oracle PL/SLQ Programming.

Simon Fox

Room 205
Rail House
Gresty Road
CREWE
Cheshire
CW2 6EA
England

01270 533997

-----Original Message-----
Sent: 17 May 2001 10:26
To: Multiple recipients of list ORACLE-L

Hi Gurus !

Is there any function that can be used in PL/SQL and just works the way as DECODE does in Sql?

Thanks in Advance

Gyula
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andor, Gyula
  INET: gy.andor_at_euromacc.hu

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

---

This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema.
If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited.

If you have received this email in error please notify the Sema UK Helpdesk by telephone on +44 (0) 121 627 5600.

---

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: FOX, Simon
  INET: Simon.FOX_at_sema.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu May 17 2001 - 04:46:44 CDT