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
Peter,
Yes whatever you put in will be what is returned. I've got about 105
million examples of that to boot. And although today you can hold the users to
a specific size, what does tomorrow hold? For the small additional price you'll
pay I'd go with a straight number.
Dick Goulet
_
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
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 the number retrieved be exactly what was put in.
For example, if they put in 0.086 the should not