|
_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')"
)
|