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

Home -> Community -> Usenet -> c.d.o.server -> Storage of NUMBER Type

Storage of NUMBER Type

From: Lawrence <lsimela_at_mahalini.prestel.co.uk>
Date: Tue, 5 Jan 1999 22:53:58 -0000
Message-ID: <76uarq$lre$1@phys-ma.sol.co.uk> 





Everyone


I would be most grateful if someone can explain the storage of the NUMBER
data type in a database column. It may seem like a simple question but:



A column defined as  Number(9,2)  stores 1234567.19  but one defined as
Number(10,2) cannot store 12345678.12



Unfortunately the manuals are not very clear on this.



Thank you in advance



Lawrence



Received on Tue Jan 05 1999 - 16:53:58 CST












Original text of this message













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