求教ORACLE中sysdate和current_timestamp的区别?

本文介绍了Oracle数据库中sysdate与current_timestamp两个函数的主要区别。sysdate返回服务器当前时间,而current_timestamp则考虑了时区设置,返回经过时区调整的日期时间。通过SQL示例展示了两者在不同设置下的输出差异。

求教ORACLE中sysdate和current_timestamp的区别?

  Oracle
专业回答
198901245631    java工程师  宇鹏网络java工程师
2015-07-05 13:48
sysdate返回的是服务器的当前时间;
sql:select sysdate from dual;此时查询的是日期的类型。
current_timestamp:它和设置的时区是有一定关系的。返回的日期和时间会根据时区转换过的。
sql:
alter session set time_zone='UTC';//设置时区
sql:SELECT TO_CHAR(SYSDATE,'YYYYMMDD HH24:MI:SS'), CURRENT_TIMESTAMP FROM DUAL;
查询结果:20150705 13:46:10 2015-07-05 13:46:10.120123。
INSERT INTO CP_QUOTA_WORKHOUR_STANDARD_DETAIL ( ID, QUOTA_STANDARD_ID, MAT_DEFINITION, PIPE_DIA_STANDARD_ID, THICKNESS_STANDARD_ID, WAY_ID, QUOTA_WORKHOUR, CREATE_USER_NO, CREATE_USER_NAME, CREATE_DATE, UPDATE_USER_NO, UPDATE_USER_NAME, UPDATE_DATE ) SELECT S_CP_QUOTA_WORKHOUR_STANDARD_DETAIL_ID.NEXTVAL, A.* FROM ( SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL union all SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, ? AS QUOTA_WORKHOUR, ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL ) A 2025-11-11T15:51:02.141+08:00 DEBUG 2732 --- [service-piping] [nio-8080-exec-1] c.c.r.p.q.m.C.insertBatch : ==> Parameters: 288(Long), 碳钢(String), 112(Long), 960(Long), 301(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 256(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 248(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 247(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 255(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 254(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 253(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 252(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 251(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 250(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 230(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 246(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 245(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 244(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 243(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 242(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 241(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 240(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 239(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 238(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 237(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 236(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 235(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 234(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 233(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 232(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 231(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 229(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 228(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 227(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 226(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 225(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 224(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 223(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 222(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 221(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 220(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 219(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 218(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 217(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 216(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 215(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 214(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 213(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 212(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 211(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 210(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 209(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 208(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 207(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 206(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 205(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 204(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 203(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 202(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 201(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 200(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 199(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 198(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 197(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 196(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 195(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 194(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 193(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 192(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 191(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 190(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 189(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 188(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 187(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 186(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 185(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 184(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 183(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 182(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 181(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 180(Long), null, Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String), 288(Long), 碳钢(String), 112(Long), 960(Long), 179(Long), 1.5(BigDecimal), Y010066(String), 薛天豹(String), Y010066(String), 薛天豹(String) 2025-11-11T15:51:02.696+08:00 ERROR 2732 --- [service-piping] [nio-8080-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: ORA-01790: 表达式必须具有与对应表达式相同的数据类型
最新发布
11-12
你遇到的错误: ``` ORA-01790: 表达式必须具有与对应表达式相同的数据类型 ``` 是因为你在 `UNION ALL` 查询中,某些字段在不同 `SELECT` 子句中的数据类型不一致,导致 Oracle 无法自动匹配类型,从而抛出错误。 --- ### 问题分析 你使用了多个 `SELECT ... FROM DUAL` 并通过 `UNION ALL` 合并结果,Oracle 要求 **每个 `SELECT` 的字段类型必须一致**,否则会报错 `ORA-01790`。 从你的日志中可以看到,有一行数据是这样的: ```java ..., 1.5(BigDecimal), ... ``` 而其他行中,该字段的值是 `null`,例如: ```java ..., null, ... ``` Oracle 会将 `null` 看作 `NULL` 类型,而 `1.5` 是数值类型(NUMBER),导致这两个字段的类型不一致,从而报错。 --- ### ✅ 解决方法 你需要确保所有 `SELECT` 中的字段类型一致,尤其是 `QUOTA_WORKHOUR` 字段。 #### 方法一:统一字段类型(推荐) 将所有 `QUOTA_WORKHOUR` 字段都转换为 `NUMBER` 类型: ```sql SELECT ... TO_NUMBER(NULL) AS QUOTA_WORKHOUR, ... FROM DUAL ``` 或使用 `0` 或其他默认值代替 `NULL`: ```sql SELECT ... NVL(#{quotaWorkhour}, 0) AS QUOTA_WORKHOUR, ... FROM DUAL ``` #### 方法二:显式统一类型 在每个 `SELECT` 中显式使用 `TO_NUMBER()`: ```sql SELECT ... TO_NUMBER(NULL) AS QUOTA_WORKHOUR, ... FROM DUAL UNION ALL SELECT ... TO_NUMBER('1.5') AS QUOTA_WORKHOUR, ... FROM DUAL ``` 或者在 Java 中传参时统一为 `BigDecimal` 类型,并在 SQL 中使用绑定变量处理。 --- ### ✅ 示例修复后的 SQL(部分) ```sql SELECT S_CP_QUOTA_WORKHOUR_STANDARD_DETAIL_ID.NEXTVAL, A.* FROM ( SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, TO_NUMBER(?) AS QUOTA_WORKHOUR, -- 强制转为 NUMBER ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL UNION ALL SELECT ? AS QUOTA_STANDARD_ID, ? AS MAT_DEFINITION, ? AS PIPE_DIA_STANDARD_ID, ? AS THICKNESS_STANDARD_ID, ? AS WAY_ID, TO_NUMBER(?) AS QUOTA_WORKHOUR, -- 强制转为 NUMBER ? AS CREATE_USER_NO, ? AS CREATE_USER_NAME, SYSDATE AS CREATE_DATE, ? AS UPDATE_USER_NO, ? AS UPDATE_USER_NAME, SYSDATE AS UPDATE_DATE FROM DUAL ) A ``` --- ### ✅ 建议 - **避免字段类型混用**,如 `NULL` `NUMBER` 混合。 - 使用 `TO_NUMBER(NULL)` 显式指定字段类型。 - 如果使用 MyBatis,确保传入参数类型一致。 - 可以在数据库中设置字段默认值或非空约束,避免类型混乱。 ---
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值