Sqlplus Getting rid off exponential values
SQL> select messagelogid from ipx.message_transaction_log where vsize(userdata)= 256;
MESSAGELOGID
------------
2.5865E+10
2.5867E+10
2.5867E+10
2.5962E+10
SQL> column messagelogid format 99999999999999999999999
SQL> select messagelogid from ipx.message_transaction_log where vsize(userdata)= 256;
MESSAGELOGID
------------------------
25864943806
25867126552
25867145531
25961831675