Storage of numeric data

2002-07-16 Thread Schauss, Peter
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

RE: Storage of numeric data

2002-07-16 Thread Paula_Stankus
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

Re: Storage of numeric data

2002-07-16 Thread Jan Pruner
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

Re: Storage of numeric data

2002-07-16 Thread Igor Neyman
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

RE: Storage of numeric data

2002-07-16 Thread Schauss, Peter
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

RE: Storage of numeric data

2002-07-16 Thread Khedr, Waleed
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

Re:RE: Storage of numeric data

2002-07-16 Thread dgoulet
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

RE: Storage of numeric data

2002-07-16 Thread Khedr, Waleed
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

Re: Data storage for Numeric data

2001-06-15 Thread Vladimir Begun
On Jun 13, 2001 at 05:01:29AM, Cale, Rick T (Richard) wrote: Hi All, If I have fields defined as NUMBER(2,0) and NUMBER(7,0) how much storage does Oracle used if fields are NULL or the fields do not use entire width. Nothing if a field contains NULL and locates at the end of row 1 byte

RE: Data storage for Numeric data

2001-06-13 Thread Cale, Rick T (Richard)
Hi All, If I have fields defined as NUMBER(2,0) and NUMBER(7,0) how much storage does Oracle used if fields are NULL or the fields do not use entire width. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED]

Data storage for numeric data

2001-06-12 Thread Cale, Rick T (Richard)
Hi All, If I have fields defined as NUMBER(2,0) and NUMBER(7,0) how much storage does Oracle used if fields are NULL or the fields do not use entire width. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED]