In environnement sqlplus

Numwith = 5O it's the max

-----Message d'origine-----
De : Amar P. Singh [mailto:oracledba-ezmlmshield-x56964996.[Email address protected]
Envoyé : jeudi 1 juin 2006 17:03
À : LazyDBA Discussion
Objet : 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


Oracle LazyDBA home page