Yes it does.
-Original Message-
Sent: Tuesday, July 16, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Dick,
Thanks for the feedback. At this point it appears that I can hold
the users to a predefined size and precision. Does Oracle store
fixed point numbers in such a way tha
Nothing wrong using Oracle data type number.
It's perfect for this kind of usage.
Regards,
Waleed
-Original Message-
Sent: Tuesday, July 16, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
We have an mechanical CAD application where we will be storing
values like bolt diameter
Dick,
Thanks for the feedback. At this point it appears that I can hold
the users to a predefined size and precision. Does Oracle store
fixed point numbers in such a way that you get back exactly what you
entered?
Thanks,
Peter Schauss
-Original Message-
Sent: Tuesday, July 16, 2002 1
Peter,
You will get out whatever you put in with just regular NUMBER type.
Format like number(4,3) only controls/constraints the number you write into
this column. You could use it, if you know in advance that you will never
try to write bigger numbers, or with more significant digits, or you wa
Use VARCHAR2 and don't worry about it. :-)
JP
On Tuesday 16 July 2002 17:48, you wrote:
> We have an mechanical CAD application where we will be storing
> values like bolt diameter and hole sizes. As far as I know,
> these numbers will not be used in any computations, but it is
> important the
Title: RE: Storage of numeric data
If you specifically want precision and scale and you know the data entered should be numeric I would make it numeric.
-Original Message-
From: Schauss, Peter [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 16, 2002 11:48 AM
To: Multiple recipients
