select large_number from mytable;

LARGE_NUMBER
------------
4.1142E+11

##</code><code>##

select to_char(large_number) from mytable;

LARGE_NUMBER
------------
411420431014

##</code><code>##

select to_char(large_number,'999999999999') from mytable;

LARGE_NUMBER
------------
411420431014