shell脚本将txt文件导入oracle
append into table $tablename
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"
)
