You need to define what you want your number output to look like:

SQL> set numformat 999,999,999,999,999,999,999,999,999,999.00
SQL> select 12233445566778899 from dual;

12233445566778899
-------------------------------------------
12,233,445,566,778,899.00



-----Original Message-----
From: Amar P. Singh
[mailto:oracledba-ezmlmshield-x56964996.[Email address protected]
Sent: Thursday, June 01, 2006 10:03 AM
To: LazyDBA Discussion
Subject: Inserting Big numbers displays calue in Exponential form


Hi Gurus~

Ok now I have a table with number data type and when I am inserting the
data with length of 16 or above it shows me the value in expontial
format. Can you tell me how to see the full values.



Eg insert into temp1 values(12233445566778899);



Select * from temp1;

1.22334455667789E16



Why this exponential E in record?



With Regards,



Amar P Singh





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html

This communication is intended for the use of the recipient to which it is
addressed, and may contain confidential, personal and or privileged
information. Please contact us immediately if you are not the intended
recipient of this communication, and do not copy, distribute, or take action
relying on it. Any communication received in error, or subsequent reply,
should be deleted or destroyed.

Oracle LazyDBA home page