【导入导出】sqlldr 导入含有内嵌换行符的数据

如何加载含有内嵌换行符的数据，这里使用了使用非换行符的chr(10)来代替换行符，在加载数据时使用一个sql函数来完成该任务。
load data
infile *
into table dept
append
fields terminated by  ','
trailing nullcols
( deptno,
  dname,
  loc,
  comments "replace(:comments,'\\n',chr(10))"---注意函数的用法
 )
begindata
10,sales,hangzhou,this is the sales\noffice in hz
20,consulting,hangzhou,this is the consulting\noffice in hz
30,accounting,hangzhou,this is the accounting\noffice in hz
40,finance,hangzhou,this is the finance\noffice in hz
查询验证。
yang@ORACL> col comments for a50
yang@ORACL> select * from dept;

    DEPTNO DNAME          LOC           COMMENTS
---------- -------------- ------------- --------------------------------------------------
        10 sales          hangzhou      this is the sales
                                         office in hz
        20 consulting     hangzhou      this is the consulting
                                         office in hz
        30 accounting     hangzhou      this is the accounting
                                         office in hz
        40 finance        hangzhou      this is the finance
                                         office in hz

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22664653/viewspace-688900/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22664653/viewspace-688900/