如何加载含有内嵌换行符的数据，这里使用了使用非换行符的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