How do I use DECODE function for IF ELSE clauses 1

[barnard90]

Hi

I have employee table .It has a field called employee marital status
which are like

Marital_status
-----------
101
102
103
104
105

Actually they mean

101 = Married
102 = Widowed
103 = Single
104 = Divorced
105 = Unknown

But these values are not stored in any table .
If I select Marital_status from Employee
select marital_status from employee
I get

101
102
103
104
105

But I want to get

Married
Widowed
Single
Divorced
Unknown

How do I get that with DECODE function . Please suggest code

thanks

 

[oradba101]

DECODE(marital_status,
'101','Married',
'102','Widowed',
'103','Single',
'104','Divorced',
'105','Unknown', NULL)

Regards,



William Chadbourne
Oracle DBA

 

[SantaMufasa]

Barnard,

You can use:

SELECT ...
      ,DECODE(marital_status
              ,101,'Married'
              ,102,'Widowed'
              ,103,'Single'
              ,104,'Divorced'
              ,105,'Unknown'
              ,'Error')Marital
      ...

Let us know if this works well for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]