SQLLDR示例

c:\tmp>type dumy.sql
set echo on
select * from v$version;
drop table dumy purge;
 
create table dumy
(
id number,
init_date date,
final_date date,
item varchar2(50)
);
 
exit
c:\tmp>type dumy.ctl
load data
infile 'C:\tmp\dumy.dat'
BADFILE 'C:\tmp\dumy.BAD'
DISCARDFILE 'C:\tmp\dumy.DSC'
APPEND
INTO TABLE dumy
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
id integer external,
init_date date "mm-dd-yyyy hh24:mi:ss",
final_date date "mm-dd-yyyy hh24:mi:ss",
item char
)
c:\tmp>type dumy.dat
1,12/22/2009 0:00:00,12/29/2009 0:00:00,"BRUSH"
2,12/22/2009 0:00:00,12/27/2009 0:00:00,"COMB"