table insert

B C D E  
TABLE1     入力内容 insert into TABLE1 values(
項目１ ITEM１ CHAR UT001 'UT001',
項目２ ITEM２ NUMBER 2 2,
項目３ ITEM３ VARCHAR 1675186196 '1675186196',

="insert into "&B8&" values("

=IF(ISERROR(SEARCH("NUM",D9)),IF(ISERROR(SEARCH("DATE",D9)),"'"&E9&"',","to_date("&"'"&E9&"','yyyy-mm-dd hh24:mi:ss'"&"),"),IF(E9="","null,",E9&","))

=IF(ISERROR(SEARCH("NUM",D10)),IF(ISERROR(SEARCH("DATE",D10)),"'"&E10&"',","to_date("&"'"&E10&"','yyyy-mm-dd hh24:mi:ss'"&"),"),IF(E10="","null,",E10&","))

=IF(ISERROR(SEARCH("NUM",D11)),IF(ISERROR(SEARCH("DATE",D11)),"'"&E11&"',","to_date("&"'"&E11&"','yyyy-mm-dd hh24:mi:ss'"&"),"),IF(E11="","null,",E11&","))

posted @ 2015-03-30 12:00  taobr  阅读(302)  评论(0)  编辑  收藏  举报