mybatis oracle与mysql细节记录
2022-05-11 本文已影响0人
一介书生独醉江湖
# mysql 允许字段使用[`]符号包含，oracle 不允许;
# 下面的代码支持mysql ，但不支持oracle (ORA-00911: 无效字符)
SELECT USER_ID, CREATED_DT
FROM TB_USER
WHERE `USER_ID` = '1'
AND `CREATED_DT` = '2022-05-10'
ORDER BY CREATED_DT DESC
# ORACLE正确写法：
SELECT USER_ID, CREATED_DT
FROM TB_USER
WHERE USER_ID = '1'
AND CREATED_DT = '2022-05-10'
ORDER BY CREATED_DT DESC
