求教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
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值