append into table $tablename
fields terminated by '|'trailing nullcols
(
PHONE1,
PHONE2,
FLAG,
time_stamp
)txt文件有3个字段phone1,phone2,flag第四个字段表示当前的日期是一个默认值文件中没有的,这个应该怎么赋值给time_stamp字段?
fields terminated by '|'trailing nullcols
(
PHONE1,
PHONE2,
FLAG,
time_stamp
)txt文件有3个字段phone1,phone2,flag第四个字段表示当前的日期是一个默认值文件中没有的,这个应该怎么赋值给time_stamp字段?
append into table $tablename
fields terminated by '|'trailing nullcols
(
PHONE1,
PHONE2,
FLAG,
time_stamp "sysdate"
)
fields terminated by '|'trailing nullcols
(
PHONE1,
PHONE2,
FLAG,
time_stamp "to_char(sysdate,'yyyy-mm-dd hh24:mi:ss')"
)
time_stamp "abc"
cjwssqlldr.sh: line 104: ` time_stamp "to_char(sysdate,'yyyymmdd')"'
fileList="fileList.txt"
ctlpath="/app/tomcat/zjpii_collection/cjws"
ls -l $downloadpath | awk '{print $8}'
for fileName in `ls $downloadpath`
do
echo "
OPTIONS(
skip=0,
errors=500000)
load data
CHARACTERSET ZHS16GBK
infile '/app/tomcat/zjpii_collection/cjws/download/$fileName'
append into table $tablename
fields terminated by '|'trailing nullcols
(
MOBILE_NBR,
MUPT_NBR,
FLAG,
AREA_CODE "substr(:MUPT_NBR,2,3)"
time_stamp "sysdate"
)
" > $ctlpath/control.ctl$ORACLE_HOME/bin/sqlldr cdr/cdr control=$ctlpath/control.ctl log=$ctlpath/control.log bad=$ctlpath/control.bad rows=1000
#del logfile
rm -fr $downloadpath/$fileName
done