Thank you all who took the time to answer the above question.
Now, I am going to allow columns types as floating.
I copied all the replies to this question so that somebody could benefit
from this. Once again thanks to Dick Goulet, Kevin Lange, David A. Barbour,
Galen Boyer.
Replies to the abo
On Wed, 15 Aug 2001, [EMAIL PROTECTED] wrote:
> In one of our applications, my boss wants to define all the
> numeric columns as NUMBER or leave it as floating point. He
> wants to define all the tables like this wherever numeric
> column is defined in the table.
>
> Example:
>
> Location_ID
Wednesday, August 15, 2001, 2:10:58 PM, David wrote:
>If for whatever reason this becomes a four-digit number
>(skip the technical explanations of why that will NEVER
>happen, just think of the logical approach - we dial 1 to
>get long-distance, why not a an additional digit(s) to
>access a region
swara"
ardp3.com>cc:
Sent by: Subject: Usage of Number type for
table columns
[EM
I hate to be on the side of management but much time is spent going
back and resizing fields and applications because the field defined is no
longer big enough. Been there and done that many times.
-Original Message-
Sent: Wednesday, August 15, 2001 10:41 AM
To: Multiple recipient
List,
In one of our applications, my boss wants to define all the numeric columns
as NUMBER or leave it as floating point. He wants to define all the tables
like this wherever numeric column is defined in the table.
Example:
Location_ID NUMBER
We know, from our application character, that th