SQL Loader

oracle@venu1> export ORACLE_SID=venu
oracle@venu1> sqlplus / as sysdba
SQL> startup

oracle@venu1> vi case1.ctl
load data
infile *
into table dept1
fields terminated by ',' optionally
enclosed by '"'
(deptno,dname,loc)
begindata
10,"research","hyderabad"
20,"mrk","banglore"
:wq!

SQL> conn scott/tiger
scott> select * from tab;
scott> create table dept1 as select * from dept where 1=2;
scott> select * from tab;
scott> select * from dept1;
scott> desc dept1
oracle@venu1> which sqlldr
oracle@venu1> export ORACLE_SID=venu
oracle@venu1> sqlldr control=case1.ctl log=case1.log
username : scott
password : tiger
SQL> select * from dept1;

oracle@venu1> vi case2.ctl
load data
infile 'case2.dat'
insert into table emp1
(empno position(01:04) internal external,
ename position(06:15) char,
job position(19:24) char,
mgr position(26:30) internal external,
sal position(33:39) decimal external,
comm position(41:48) decimal external,
deptno position(51:55) internal external)
:wq!

scott> create table emp1 as select * from emp where 1=2;
scott> select * from emp1;
oracle@venu1> sqlldr control=case2.ctl log=case2.log data=case2.dat
username : scott
password : tiger
scott> select * from emp1;

oracle@venu1> vi case3.ctl
load data
infile *
append
into table dept1
fields terminated by ',' optionally
enclosed by '"'
(deptno,dname,loc)
begindata
11,"re","hyd"
:wq!
scott> select * from dept1;
oracle@venu1> sqlldr control=case3.ctl log=case3.log
username : scott
password : tiger
scott> select * from dept1;