upload data using sqlldr by conditinig
I need to upload data to oracle DB by using sqlldr. but need to uplaod col1 values =15. secondly need to add to oracle name of the txxt file with eash record.
data to be uploaded in oracle. table structure
create table CDR(
col1 number(4),
col2 number(20),
col3 number(10),
col4 number(2),
col5 number(10),
col6 number(10),
col7 number(20),
col8 date,
col9 number(20),
col10 char(20))
create table CDR_DUP(
col1 number(4),
col2 number(20),
col3 number(10),
col4 number(2),
col5 number(10),
col6 number(10),
col7 number(20),
col8 date,
col9 number(20),
col10 char(20))
data receive to upload to oracle in text format
name of the file.20101207media_cdr_12