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




Oracle LazyDBA home page