SELECT CASE WHEN 性别列的列名=0 THEN '男' WHEN 性别列的列名=1 THEN '女'END as sex, age_colname as ageFROM 你要查找的表名WHERE 条件子句 转载于:https://www.cnblogs.com/hanje/p/oracle.html