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

• #education
• #how
• #to
• #use
• #sql
• #loader
• #sqlldr
• #load
• #data
• #into
• #table