1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| LOAD DATA
INTO TABLE gen$mis.missasratecsp
APPEND
when rate_type='BUDGET'
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( year_code CHAR,
currency_code CHAR,
rate_val FLOAT EXTERNAL "to_number(replace(replace(:rate_val, ',', '.'), ' ', ''), '999999999999999999999999999999D999999', ' NLS_NUMERIC_CHARACTERS = ''. ''')",
rate_type CHAR
)
INTO TABLE gen$mis.missasratecsp
APPEND
when rate_type='T2'
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
( year_code CHAR,
currency_code CHAR,
rate_val FLOAT EXTERNAL "to_number(replace(replace(:rate_val, ',', '.'), ' ', ''), '999999999999999999999999999999D999999', ' NLS_NUMERIC_CHARACTERS = ''. ''')",
rate_type CHAR
) |
Partager