sql loader with bad and discard file
***** Control file.ctl ******
options(skip=1)
load data
infile 'D:\SQL_LOADER_DEMO\data_file.txt'
badfile 'kuldeep_bad.bad'
discardfile 'kuldeep_discard.dsc'
insert into table TEST
when location !='pune'
fields terminated by ','
(NAME,JOB,SAL,DEPT,LOCATION)
** Data_file.txt*****
name,job,sal,dept,location
kuldeep,L2,40,10A,mumbai
pradeep,pharm,30,20A,mumbai
sandeep,L3,25A,20A,mumbai
santosh,L3,40,20A,pune
****** CMD screen *********
sqlldr userid= username/password
control = control_file.ctl
CREATE TABLE TEST
(
NAME VARCHAR2(100 BYTE),
JOB VARCHAR2(50 BYTE),
SAL NUMBER,
DEPT VARCHAR2(30 BYTE),
LOCATION VARCHAR2(30 BYTE)
)