How to use Oracle SQL Loader sqlldr to load data into table from text file
How to use Oracle SQL Loader sqlldr to load data into table from text file
create table emp(empno number(10),ename varchar(30));
insert into emp values(10,'asif');
set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on
spool d:\oradata\sqlloader\data.txt
select empno || ',' || ename from emp;
spool off
delete emp;
update file named data.txt
create a file named control.txt
load data
infile 'd:\oradata\sqlloader\data.txt'
into table emp
fields terminated by "," optionally enclosed by '"'
( empno, ename )
sqlldr asif/asif control=d:\oradata\sqlloader\control.txt
