1、不用CASE,用NVL函数即可:
SELECT sid,NVL(sname,'姓名为空' ) from stuinfo;
2、CASE:
SELECT sid,
CASE WHEN snameIS NULL THEN '姓名为空' ELSE sname END CASE
from stuinfo;
SELECT sid,NVL(sname,'姓名为空' ) from stuinfo;
2、CASE:
SELECT sid,
CASE WHEN snameIS NULL THEN '姓名为空' ELSE sname END CASE
from stuinfo;