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

Comments