我想问下 原来我这样写load data
infile 'C:\Documents and Settings\Administrator\桌面\数据文件.txt'
append into table 表名 //append 或者 replace
fields terminated by ';' //分隔符
(
EMAIL CHAR,
insert_date sysdate
) 我现在不想要date类型的,改成insert_date char \"nvl(to_char(sysdate,'mmddhh24miss',' ')\"
是不是这样?
infile 'C:\Documents and Settings\Administrator\桌面\数据文件.txt'
append into table 表名 //append 或者 replace
fields terminated by ';' //分隔符
(
EMAIL CHAR,
insert_date sysdate
) 我现在不想要date类型的,改成insert_date char \"nvl(to_char(sysdate,'mmddhh24miss',' ')\"
是不是这样?
INFILE 'C:\Documents and Settings\Administrator\桌面\数据文件.txt'
APPEND INTO TABLE 表名
FIELDS TERMINATED BY ';'
TRAILING NULLCOLS
(email "NVL(:email ,' ')",insert_date "NVL(:insert_date,TO_CHAR(SYSDATE,'mmddhh24miss'))")