Explain: decode? 1

[00112233]

Hello and thanks in advance:



Could anybody explain me this SQL statement?



------------------------------------------------

decode(e.domain,'SERV','LABOUR', 'PARTS') Domain

------------------------------------------------



It is my understanding that we should have another 'e.domain' just before the closing bracket. Then 'SERV' gets decoded into 'LABOUR' but what 'PARTS' get decode into?



If we want 'PARTS' to stay as is (I have looked at the data.... And it looks like so...) shouldn't this statement look like:



------------------------------------------------------

decode(e.domain,'SERV','LABOUR', 'PARTS', 'PARTS', e.domain) Domain

------------------------------------------------------



or better:



-------------------------------------------------

decode(e.domain,'SERV','LABOUR', e.domain) Domain

-------------------------------------------------



since we do not need to decode "PARTS' into anything?





Thanks for your help.











------------------------------------------------------------
Vancouver Education: find out about continuing education in Canada and Vancouver. Get program highlights and request more information. Free courses available!

http://www.vancouverfinder.org/education/education-vancouver.html

Your Vancouver City Guide

http://www.vancouverfinder.org/

- Your Vancouver Guide

 

[swampBoogie]

The last parameter to decode will be used when no match is found.
i.e. if the column domain is not equal to 'SERV' the value 'PARTS' is returned.

Decode is non-standard. Use a case expression instead

case when e."DOMAIN" = 'SERV' then 'LABOUR'
   else 'PARTS' end as "DOMAIN"

Even Oracle supports it.

 

[00112233]

Thanks!!!!!!!!!

Quick reply...

Your Vancouver City Guide

http://www.vancouverfinder.org/

- Your Vancouver Guide