Thursday, November 7, 2013

Converting exponential value to numeric

e.g.
select 1987252000000000000 from dual
1.987252E18

Check this:
select to_char(''||1987252000000000000) from dual
1987252000000000000

No comments:

Post a Comment