PL/SQL - DECODE

From: Nandakumar <nanban_at_my-deja.com>
Date: Mon, 02 Aug 1999 18:23:34 GMT
Message-ID: <7o4nmp$b5$1@nnrp1.deja.com>

What is the equivalent of decode (of SQL) in PL/SQL? Any SWITCH/WHEN/CASE are available in PL?SQL???

It appears like DECODE is not allowed in PL/SQL!! PLS-00204: function or pseudo-column 'DECODE' may be used inside

a SQL statement only
--
Nandakumar
Systems Analyst
New York
(N.Kumar_at_rocketmail.com)

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Aug 02 1999 - 13:23:34 CDT