函数nvl 和decode

decode(nvl(kkc.category, 'one'),'one','普通','two','精品','three','行业','four','白金') 
原文地址:https://www.cnblogs.com/feiyun126/p/5659717.html