ORACLE case when 语句

总是记不住，做一下记录。。

END AS 后加别名。

SELECT USER_NAME,
CASE WHEN PASS_WORD='123456789' THEN '密码过于简单' ELSE PASS_WORD END AS ECHO_PASSWORD,
CASE WHEN AGE>=18 THEN '成年人' ELSE '未成年' END AS ECHO_AGE
FROM SYS_USER;