Re: SQL server 7 equivalent code in Oracle?
Date: 2000/06/12
Message-ID: <8i3vkf$n50_at_chronicle.concentric.net>#1/1
Hello SP,
[Quoted] You want to use DECODE:
SELECT d.departmentid,
[Quoted] dept=DECODE(p.departmentID,p.departmentID<100,'Video',DECODE(p.departmentID,
p.departmentID<200
[Quoted] [Quoted] ,'CD-ROM',DECODE(p.departmentID,p.departmentID<300,'Book','DVD')))
from product p, department d
[Quoted] [Quoted] In a Nutshell it is: decode(<CASE>,<WHEN>,<THEN>,<ELSE>)
Hope this helps
Mary
mdellamalva_at_cetec.com
SP <spant1_at_aol.com> wrote in message
[Quoted] news:MVe15.1169$Qf6.46762_at_nuq-read.news.verio.net...
> I've this SQL code inside a PL/SQL body. But this is in SQL server 7.
Can
> anyone suggest eqivalent code in Oracle.
> SELECT d.departmentid,
> 'dept'=CASE
> WHEN p.departmentID<100
> THEN 'Video'
> WHEN p.departmentID<200
> THEN 'CD-ROM'
> WHEN p.departmentID<300
> THEN 'Book'
> ELSE 'DVD'
> END
> from product p, department d
> where d.prodID = p.prodID
> order by dept desc
>
> Thanks,
> SP
>
>
Received on Mon Jun 12 2000 - 00:00:00 CEST