Hi all,
I am facing a problem with loading data from excel file.
Table
CREATE TABLE "TESTING"."A"
( "A" VARCHAR2(10),
"B" VARCHAR2(20),
"C" VARCHAR2(10)
)
Datafile
1,"sample,test",10
2,"sample>test,testing",20
Control file
load
infile 'load.dat'
into table a
fields terminated by ',' optionally enclosed by " "
(a,b,c)
After loading
Select * from a;
A B C
---------- -------------------- ----------
1 "sample test"
2 "sample>test testing"
I am not able to load the 10 and 20 in the dat file.
Please help.
Also Searched and still seraching the google.
Thanks inm Advance
SALIH KM