oracle sql踩过的坑,ORACLE SQL 兼容性写法踩坑笔记

ORA-00936: missing expression

select * from t_user where id in()当条件in的内容为空时抛ORA-01795: maximum number of expressions in a list is 1000

select * from t_user where id in(‘aaa’,’bbb’,’ccc’)当in 的内容超过1000会报错数据库表解锁CALL SYSPROC.ADMIN_CMD('REORG TABLE DB2INST1.CSC_CALLTASKLINE';

Mybatis 批量写入Oracle保存报错：ORA-00933: SQL 命令未正确结束

错误写法：

INSERT INTO PLM_CASPEC_EVAL_LINE(

EVAL_ID,

COM_ID,

ITEM_ID,

CA_SPEC_EVAL,

CA_SPEC

)VALUES

(

#{item.evalId},

#{item.comId},

#{item.ITEM_ID},

#{item.KIND},

#{item.KIND}

)

正确写法：

INSERT INTO PLM_CASPEC_EVAL_LINE(

EVAL_ID,

COM_ID,

ITEM_ID,

CA_SPEC_EVAL,

CA_SPEC

)

(

SELECT

#{item.evalId},

#{item.comId},

#{item.ITEM_ID},

#{item.KIND},

#{item.KIND}

FROM

SYSIBM.SYSDUMMY1

DUAL

)

oracle 查询空为null的问题：