oracle 相关

 1.

case用法。

SELECT * FROM (SELECT rownum rm,Serial_num,
(CASE LOGTYPE
WHEN '1' THEN '新增'
WHEN '2' THEN '修改'
WHEN '3' THEN '删除'
WHEN '4' THEN '查询'
WHEN '5' THEN '登入'
WHEN '6' THEN '登出'
WHEN '7' THEN '批次导入'
WHEN '8' THEN '生成回执'
else '其他'
end
)as logType,description,content,TO_CHAR(CREATE_DATE,'YYYY.MM.DD') CREATE_DATE,userid,MENU_ID FROM T_LogInfo WHERE  DELETEFLAG=1 AND rownum<99 ORDER BY Serial_num DESC) where rm>0