create table dept(dno number(7),dname varchar2(40));

load data
into table dept
append
fields terminated by ',' optionally enclosed by ' " '
(dno,
dname)

"1","acct"
"2","it"

sqlldr userid=gautam/gautam@gwcm control=tctl.ctl data=tinput.dat

SQL*Loader: Release 10.2.0.1.0 - Production on Fri Aug 17 10:36:51 2007

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

Control File:   tctl.ctl
Data File:      tinput.dat
  Bad File:     tinput.bad
  Discard File:  none specified
 
 (Allow all discards)

Number to load: ALL
Number to skip: 0
Errors allowed: 50
Bind array:     64 rows, maximum of 256000 bytes
Continuation:    none specified
Path used:      Conventional

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

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
DNO                                 FIRST     *   ,       CHARACTER            
    Enclosure string : ' " '
DNAME                                NEXT     *   ,       CHARACTER            
    Enclosure string : ' " '

Record 1: Rejected - Error on table DEPT, column DNO.
ORA-01722: invalid number

Record 2: Rejected - Error on table DEPT, column DNO.
ORA-01722: invalid number


Table DEPT:
  0 Rows successfully loaded.
  2 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.

optionally enclosed by ' " '

optionally enclosed by '"'

create table emp(eno number(4),dno number(4),dname varchar2(20))

"1","acct"
"2","1","acct"
"1","it"
"2","2","it"

load data
into table dept
append
fields terminated by ',' optionally enclosed by '"'
(dno,
dname)
into table emp
append
fields terminated by ',' optionally enclosed by '"'
(eno,
dno,
dname)

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

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
DNO                                 FIRST     *   ,  O(") CHARACTER            
DNAME                                NEXT     *   ,  O(") CHARACTER            

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

   Column Name                  Position   Len  Term Encl Datatype
------------------------------ ---------- ----- ---- ---- ---------------------
ENO                                  NEXT     *   ,  O(") CHARACTER            
DNO                                  NEXT     *   ,  O(") CHARACTER            
DNAME                                NEXT     *   ,  O(") CHARACTER            

Record 1: Rejected - Error on table EMP, column ENO.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 2: Rejected - Error on table EMP, column DNO.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 3: Rejected - Error on table EMP, column ENO.
Column not found before end of logical record (use TRAILING NULLCOLS)
Record 4: Rejected - Error on table EMP, column DNO.
Column not found before end of logical record (use TRAILING NULLCOLS)

Table DEPT:
  0 Rows successfully loaded.
  4 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.