Load multi currency data into table
I am facing as issue while loading multi currency data into table by using sql*loader.
For ex: Table name as XX_TEST having column name as AMOUNT varchar2(100)
getting below data in the format of .csv file
Amount
-----
£250.00
$ 3,700.00
Script which is being used as of now.
---------
OPTIONS
(SKIP = 1)
load data
CHARACTERSET WE8ISO8859P1
BYTEORDER LITTLE
infile 'TRA_STG.csv'
REPLACE into table XX_TEST
fields terminated by "," optionally enclosed by '"'TRAILING NULLCOLS(AMOUNT)
Regards,
Visu