{SQL Loader}ダイレクトパスロードでSQL*Loaderを実行

 

https://docs.oracle.com/cd/F19136_01/sutil/oracle-sql-loader-conventional-and-direct-loads.html#GUID-A491440D-63A4-4781-9292-B822DDDF9BF3

vi example4.dat
hello,"world",###
james,"bond",###

vi example4.ctl
load data
infile 'example4.dat'  "str '###\n'"
into table example4 append
fields terminated by ',' optionally enclosed by '"'
(col1 ,col2 )

create table test.example4(col1 varchar2(100),col2 varchar2(100));
sqlldr test/test@orcl DIRECT=TRUE control=example4.ctl data=example4.dat

select * from test.example4;