|
The DECODE function is supported on a SQL
Server database. When using SQL Server, the DECODE function is
converted to the CASE function. For example, the following
statement:
SELECT DECODE(type, 'popular_comp', 'Popular
Computing', 'mod_cook', 'Modern Cooking', 'business' ,
'Business', 'psychology', 'Psychology', 'trad_cook', Traditional
Cooking', 'Not yet categorized')
from titles
will be internally transformed
to:
SELECT CASE type
WHEN
'popular_comp' THEN 'Popular Computing'
WHEN 'mod_cook'
THEN 'Modern Cooking'
WHEN 'business'
THEN 'Business'
WHEN 'psychology'
THEN 'Psychology'
WHEN 'trad_cook'
THEN 'Traditional Cooking'
ELSE 'Not yet
categorized'
END
FROM titles
and this will be the statement
that will be sent to the database.
|
