1. Oracel 存储过程拼接字段换行
chr(9)
chr(10)
chr(13)
chr(32)
chr(34)
msg_body := '一二三四' || chr(10) || '編號: ';
一二三四
編號:
2.查询sql使用case when中不能使用<>‘’
case when nickname is not null and nickname <> '' then
rtrim(nickname) + ' ' + rtrim(eng_surname)
else
rtrim(eng_surname) + ' ' + rtrim(eng_other_name)
end AS NEW_USER_NAME,
case when e.nickname is not null and length(trim(e.nickname)) != 0 then
rtrim(e.nickname) || ' ' || rtrim(e.eng_surname)
else
rtrim(e.eng_surname) || ' ' || rtrim(e.eng_other_name)
end AS NEW_USER_NAME,
3.to_char() 格式化日期 分钟格式一定要用mi
SELECT sysdate FROM dual;
SELECT TO_CHAR(sysdate,'yyyy-MM-dd HH24:mi:ss') FROM dual;
SELECT TO_CHAR(sysdate,'yyyy-MM-dd HH24:mm:ss') FROM dual;