Re: Storage of numeric data

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 the number retrieved be exactly what was put in.
> For example, if they put in 0.086 the should not get out 0.08599).
>
> If I use a format like number(4,3), will this give me the result
> that I want or should I use char(5)?
>
> thanks,
>
> Peter Schauss
> Northrop Grumman Corporation
> schaupe_at_mail.northgrum.com

-- 
         Pruner Jan
       jan_at_pruner.cz
     http://jan.pruner.cz/
-----------------------------
Only Robinson Crusoe had all his work done by Friday
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jan Pruner
  INET: jan_at_pruner.cz

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).