Table ELOADER, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ENAME FIRST * , CHARACTER
EMPNO NEXT * , CHARACTER
SAL NEXT * , CHARACTER
COMM NEXT * , CHARACTER
PHONENUM NEXT * , CHARACTER
MGR NEXT * , CHARACTER
DEPTNO NEXT * , CHARACTER
LOCATION NEXT * , CHARACTER
JOB NEXT * , CHARACTER
QUALIFICATION NEXT * , CHARACTER

Table ELDR, loaded from every logical record.
Insert option in effect for this table: APPEND
TRAILING NULLCOLS option in effect

Column Name Position Len Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ENAME NEXT * , CHARACTER
EMPNO NEXT * , CHARACTER
SAL NEXT * , CHARACTER
COMM NEXT * , CHARACTER
PHONENUM NEXT * , CHARACTER
MGR NEXT * , CHARACTER
DEPTNO NEXT * , CHARACTER
LOCATION NEXT * , CHARACTER
JOB NEXT * , CHARACTER
QUALIFICATION NEXT * , CHARACTER

value used for ROWS parameter changed from 64 to 49

Table ELOADER:
21 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.

Table ELDR:
0 Rows successfully loaded.
0 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
21 Rows not loaded because all fields were null.

As am a beginner, the only thing i know about sql loader. It is one of the Oracle Tool will be used to transfer the data from Flat files into Oracle Base tables.Also it is a bulk loader utility.Anyways thanks for your reply blackswan.