Dear DBA's
I am loading data throgh SQL*LOADER in Oracle. I have some problem, While Inserting data into multiple table I have created Control file in followinf way which is giving me error, Second my numeric data in data file has decimal seprator "," for ex. "123,45" not "123.45" which is giving me error. Please help me.
Thanks
Shailesh
UNRECOVERABLE LOAD DATA
INFILE 't2.dat'
INSERT INTO TABLE t2
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( l1 char,l2 char,l4 char,mydate date,l3 char(2000000))
INFILE 't1.dat'
INSERT INTO TABLE t1
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( f1 char,f2 char,f4 char))
