I have a requirement where I have to perform different type of validations (onscreen) based on calculations that involves 10 digits up to 2 decimal places (ex: 8542137887.12). when I am trying to achieve same using decimal data type it is getting converted into Exponential format. can any one suggest me some workaround?Note: calculations involve multiplication, division addition and subtraction.
OriginalPostID-199279
Discussion posts and replies are publicly visible
When we do import from csv to database, Does the decimal numbers converts into exponential format( if the Oracle DB column is varchar)?