Today I found out that the AWS usage report, some usages are showing up as E-notation(for example, 1.6E-5 which shall be 1.6×10−5. That broken my code as I am trying to load them into my Oracle table as numbers.
SO I will need to find a way to to a transfer, after awhile, here is the working soultions
round(decode(instr(UsageQuantity,'E'),0,UsageQuantity,to_number(replace(UsageQuantity,' ',''),'9.99999999999999999999EEEE')),2),
Thx.
No comments:
Post a Comment