case 语句的用法

Question

select MAT_NM_TEMP =
 decode(type,'popular_comp','Popular Computing')
from KPLAN_Ldecode(substr(t0.cag_no,1,1),1,'ab',2,'cd',3,'ef')

Answer 1

select decode(type,'popular_comp','Popular Computing') MAT_NM_TEMP from KPLAN_L

Answer 2

酱紫也可以DI
select case type when 'popular_comp' then 'Popular Computing' end MAT_MM_TEMP
from KPLAN_L

Answer 3

Nickle_Final的SQL：未找到预期 FROM 关键字

Answer 4

case when then 是T-SQL语法撒
oracle里有这东东吗？
这是sql server论坛还是oracle?
oracle用decode啦