日期:2014-05-18  浏览次数:20879 次

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