Oracle to_date函数的问题
insert into TM_PART_MAIN_DATA (ID, PART_NUMBER, RELEASE_DATE, MOP_CODE, REPLACE_RELATION, EWO, REPLACING_PART_NUMBER, DATA_SOURCE, PART_NAME_EN, CONFIRM_CODE, ACTUAL_BP_DATE, ACD_FLAG, FORECAST_BP_DATE, SERVICE_CODE, REPLACE_VALID_DATE, SOURCING, DIRECT_DISTRIBUTE_FLAG, OPTIONAL, MONITOR_FLAG, TRACEABLE_FLAG, MAIN_HIDDEN_FLAG, HIDDEN_FLAG_CHANGE_DATE, MAIN_SAP_FLAG, MAIN_SAP_FLAG_FINISH_DATE, PACKAGE_FLAG, PACKAGE_FIRST_FINISH_DATE, PURCHASE_FLAG, PURCHASE_FLAG_FINISH_DATE, FILTER_FLAG, FILTER_FLAG_FINISH_DATE, REF_FLAG, REF_FLAG_FINISH_DATE, PURCHASE_AVAILABLE_DATE, PACKAGE_AVAILABLE_DATE, PRICING_FLAG, PRICING_FIRST_FINISH_DATE, PACKAGE_DELAY_START_DATE, PACKAGE_DELAY_TIME, PURCHASE_DELAY_TIME, PURCHASE_DELAY_START_DATE, PACKAGE_HOLD_TIME, BUY_FLAG, STOP_BUY_DATE, CREATE_BY, PURCHASE_HOLD_TIME, CREATE_DATE, PURCHASE_CANCEL_TIME, CCC_FLAG, PAINT_FLAG, UPDATE_BY, BOOK_HIDDEN_PKG_TIME, BOOK_CODE, FSU, QTY_OF_VEHICLE, SERIES_CODE, BODY_CODE, HAND, DFS_FLAG, PROVIDER_FLAG, UPDATE_DATE, BOOK_HIDDEN_PHS_TIME, UPC, FNA)
values (2015681, 'DNC101410 ', to_date( '25-01-2007 08:36:25 ', 'dd-mm-yyyy hh24:mi:ss '), '国产 ', 'USEM ', null, 'DNC90141A ', '4 ', 'HOSE&JET ASSY-WSH SYS ', '20061112 ', null, 'D ', null, 'N ', to_date( '11-04-2007 12:10:38 ', 'dd-mm-yyyy hh24:mi:ss '), null, '0 ', null, '0 ', '0 ', '0 ', null, '1 ', to_date( '25-01-2007 10:59:47 ', 'dd-mm-yyyy hh24:mi:ss '), '2 ', to_date( '25-01-2007 10:34:22 ', 'dd-mm-yyyy hh24:mi:ss '), '0 ', null, '2 ', to_date( '25-01-2007 08:36:25 ', 'dd-mm-yyyy hh24:mi:ss '), '1 ', to_date( '25-01-2007 08:36:25 ', 'dd-mm-yyyy hh24:mi:ss '), to_date( '25-01-2007 10:59:47 ', 'dd-mm-yyyy hh24:mi:ss '), to_date( '25-01-2007 08:36:25 ', 'dd-mm-yyyy hh24:mi:ss '), '1 ', to_date( '25-01-2007 11:22:58 ', 'dd-mm-yyyy hh24:mi:ss '), null, 0, 0, to_date( '25-01-2007 10:59:47 ', 'dd-mm-yyyy hh24:mi:ss '), 0, '2 ', to_date( '02-07-2007 03:00:00 ', 'dd-mm-yyyy hh24:mi:ss '), -1, 0, to_date( '25-01-2007 08:36:25 ', 'dd-mm-yyyy hh24:mi:ss '), 0, '0 ', '0 ', -1, 0, 'W ', null, '2 ', 'R1,R2 ', null, null, '1 ', '1 ', to_date( '11-04-2007 12:10:39 ', 'dd-mm-yyyy hh24:mi:ss '), 0, '0 ', '0 ');
这个是我从一个数据库中导出的脚本N多语句中的一条,想插入另一张表
在TOAD中执行的时候一直会弹出
' ' is not a valid da