Filler use in sqlloader

Filler use in sqlloader

SQL> select * from emp31;

no rows selected

SQL> select * from emp32;

no rows selected

****************************emp.txt**********************

7369,SMITH,7902,17-DEC-80,800,,20

7499,ALLEN,7698,20-FEB-81,1600,300,30

7521,WARD,7698,22-FEB-81,1250,500,30

7566,JONES,7839,02-APR-81,2975,,20

7654,MARTIN,7698,28-SEP-81,1250,1400,30

7698,BLAKE,7839,01-MAY-81,2850,,30

7782,CLARK,7839,09-JUN-81,2450,,10

7788,SCOTT,7566,19-APR-87,3000,,20

7839,KING,,17-NOV-81,5000,,10

7844,TURNER,7698,08-SEP-81,1500,0,30

7876,ADAMS,7788,23-MAY-87,1100,,20

7900,JAMES,7698,03-DEC-81,950,,30

7902,FORD,7566,03-DEC-81,3000,,20

7934,MILLER,7782,23-JAN-82,1300,,10

********************************emp31.ctl*********************

load data

infile 'I:\SQLLOADER\emp.txt'

insert into table emp31

fields terminated by ","

optionally enclosed by '"'

(empno 

,ename

,job

,mgr

,hiredate

,sal

,comm

,deptno)

into table emp32

fields terminated by ","

(empno position(1)

,ename

,job

,mgr filler

,hiredate filler

,sal

,comm

,deptno)

*********************command prompt syntax****************

C:\Users\RAJASEKHAR>sqlldr scott/tiger@ORCL control=I:\SQLLOADER\emp31.ctl

SQL*Loader: Release 10.2.0.3.0 - Production on Wed Apr 2 14:13:30 2014

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Commit point reached - logical record count 13

Commit point reached - logical record count 14

************************output********************************

SQL> select * from emp31;

EMPNO ENAME      JOB         MGR HIREDATE    SAL  COMM DEPTNO

----- ---------- --------- ----- --------- ----- ----- ------

 7369 SMITH      CLERK      7902 17-DEC-80   800           20

 7499 ALLEN      SALESMAN   7698 20-FEB-81  1600   300     30

 7521 WARD       SALESMAN   7698 22-FEB-81  1250   500     30

 7566 JONES      MANAGER    7839 02-APR-81  2975           20

 7654 MARTIN     SALESMAN   7698 28-SEP-81  1250  1400     30

 7698 BLAKE      MANAGER    7839 01-MAY-81  2850           30

 7782 CLARK      MANAGER    7839 09-JUN-81  2450           10

 7788 SCOTT      ANALYST    7566 19-APR-87  3000           20

 7839 KING       PRESIDENT       17-NOV-81  5000           10

 7844 TURNER     SALESMAN   7698 08-SEP-81  1500     0     30

 7876 ADAMS      CLERK      7788 23-MAY-87  1100           20

 7900 JAMES      CLERK      7698 03-DEC-81   950           30

 7902 FORD       ANALYST    7566 03-DEC-81  3000           20

 7934 MILLER     CLERK      7782 23-JAN-82  1300           10

14 rows selected.

SQL> select * from emp32;

EMPNO ENAME      JOB         MGR HIREDATE    SAL  COMM DEPTNO

----- ---------- --------- ----- --------- ----- ----- ------

 7369 SMITH      CLERK                       800           20

 7499 ALLEN      SALESMAN                   1600   300     30

 7521 WARD       SALESMAN                   1250   500     30

 7566 JONES      MANAGER                    2975           20

 7654 MARTIN     SALESMAN                   1250  1400     30

 7698 BLAKE      MANAGER                    2850           30

 7782 CLARK      MANAGER                    2450           10

 7788 SCOTT      ANALYST                    3000           20

 7839 KING       PRESIDENT                  5000           10

 7844 TURNER     SALESMAN                   1500     0     30

 7876 ADAMS      CLERK                      1100           20

 7900 JAMES      CLERK                       950           30

 7902 FORD       ANALYST                    3000           20

 7934 MILLER     CLERK                      1300           10

14 rows selected.