Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Number(30)

Number(30)

From: val <minnie_nguyen_at_yahoo.com>
Date: 2 May 2007 23:30:45 -0700
Message-ID: <1178173845.798808.222440@e65g2000hsc.googlegroups.com> 





hi,


we currently have a column in our table (oracle 9i) defined as
number(30).  however, when we try to insert data that has 25 digits,
it stores the number as 1.7909364352007E23.  can you let me know why
it has exponents versus loading the number as is with 25 digits?  how
can i  change the datatype to store 25 digits.  varchar(30)?



thanks!
Received on Thu May 03 2007 - 01:30:45 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US