This content has been marked as final. Show 2 replies
Thank you for your help! The "abc" is a constant string, it isn't a column. And I use concat function to solve the problem. like this
INTO TABLE tmp_table
fields terminated by "," optionally enclosed by '"'
( c1 "concat('abc',TO_CHAR(SYSDATE, 'YYYYMMDD'))"
Edited by: Sheng on 2013-5-26 下午4:44