Technology Stack - EBS (MOSC)

MOSC Banner

Load multi currency data into table

edited Aug 20, 2021 11:31AM in Technology Stack - EBS (MOSC) 1 comment
Hi All,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center