Re: wats the difference b/w case and decode

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 07 Mar 2007 15:04:11 GMT
Message-ID: <LvAHh.24379$lY6.4498@edtnps90>

CASE in PL/SQL requires 9i or later. 8i supports CASE only in SQL.

-- 
Terry Dykstra
"Jaap W. van Dijk" <j.w.vandijk.removethis_at_hetnet.nl> wrote in message 
news:45ee7521.1553343_at_news.hetnet.nl...


> On 5 Mar 2007 23:47:31 -0800, vannalas_at_gmail.com wrote:

>

>>Hi all

>>

>>What's the difference between the case and decode functions in oracle.

>>

>>Thanks in advance.

>>

> And to add to the other responses: decode cannot be used in PL/SQL.

>

> Jaap.

Received on Wed Mar 07 2007 - 09:04:11 CST