Re: SQL server 7 equivalent code in Oracle?

[Quoted] Which version of Oracle are you using?

In comp.databases.oracle.server Mary <mdellamalva_at_cetec.com> wrote:
> Hello SP,
 

> You want to use DECODE:
 

[Quoted] > SELECT d.departmentid,
 

> dept=DECODE(p.departmentID,p.departmentID<100,'Video',DECODE(p.departmentID,
> p.departmentID<200
> ,'CD-ROM',DECODE(p.departmentID,p.departmentID<300,'Book','DVD')))
> from product p, department d
 

> In a Nutshell it is: decode(<CASE>,<WHEN>,<THEN>,<ELSE>)
 

> Hope this helps
 

> Mary
> mdellamalva_at_cetec.com
 

[Quoted] > SP <spant1_at_aol.com> wrote in message
> 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

[Quoted] [Quoted] >> 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
>>
>>

-- 
http://www.cooper.com.hk