last_update Date "yyyy-mm-dd",
entire_line "replace(:entire_line,'\\n','chr(10)')")
sqlldr userid='sys/test as sysdba' control='c:\load.ctl' log='c:\log.log'
----数据如下
10Sales"Virginia,USA""2008-01-01"this is \n aaa
20Accounting"Va,""Virginia""""2008-01-01"this is \n aaa
30ConsultingVirginia"2008-01-01"this is \n aaa
40FinanceVirginia"2008-01-01"this is \n aaa
select utl_raw.cast_to_raw(chr(6)||chr(13)||chr(10)) from dual
------------
'060D0A'
----修改load.ctl
Load data
infile 'c:\1.txt' "str X'060D0A'"
into table dept
fields terminated by X'07' optionally enclosed by '"'
trailing nullcols
(deptno,
dname char(1000) "upper(:dname)",
loc "upper(:loc)",
last_update Date "yyyy-mm-dd",
entire_line)
sqlldr userid='sys/test as sysdba' control='c:\load.ctl' log='c:\log.log'
----数据如下
10Sales"Virginia,USA""2008-01-01"this is aaa
20Accounting"Va,""Virginia""""2008-01-01"this is aaa
30ConsultingVirginia"2008-01-01"this is aaa
40FinanceVirginia"2008-01-01"this is aaa