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