当前位置：首页 -> AI编程基础 -> 数据库编程

[Oracle] SQL*Loader详细使用教程（3）- 控制文件(二)

2014-11-24 02:40:16 · 作者: · 浏览: 7
标签: Oracle SQL Loader 详细 使用 教程 控制 文件
_EXPERT_RELATION APPEND WHEN len='2' FIELDS TERMINATED BY WHITESPACE ( len FILLER POSITION(1) CHAR, DISEASEEXPERTUUID EXPRESSION "SYS_GUID()", EXPERTUUID CHAR, DISEASEUUID EXPRESSION "NULL", DISEASESORTCODE EXPRESSION "NULL", DISEASENAME CHAR, CREATEDTIME EXPRESSION "TO_CHAR(sysdate,'yyyymmddhh24miss')", MODIFIEDTIME EXPRESSION "TO_CHAR(sysdate,'yyyymmddhh24miss')" ) INTO TABLE p95169.DISEASE_EXPERT_RELATION APPEND WHEN len='1' FIELDS TERMINATED BY WHITESPACE ( len FILLER POSITION(1) CHAR, DISEASEEXPERTUUID EXPRESSION "SYS_GUID()", EXPERTUUID CHAR, DISEASEUUID EXPRESSION "NULL", DISEASESORTCODE EXPRESSION "NULL", DISEASENAME EXPRESSION "NULL", CREATEDTIME EXPRESSION "TO_CHAR(sysdate,'yyyymmddhh24miss')", MODIFIEDTIME EXPRESSION "TO_CHAR(sysdate,'yyyymmddhh24miss')" )