Hi,
I don't think there are any storage differences, because only valid digits
are stored in each case.
The restriction on length (precision) or scale gives some range check on
the number. Moreover,
using unrestricted lengths (especially for character strings) can cause
difficulties in products
like SQL*Plus, because memory allocation for fetching records is done based
on the declared
length, not based on the actual length of the item.
Regards,
--
Pavel Polcar
Kevin Barnes <kbarnes_at_airmail.net> wrote in article
<3559E317.2994872_at_airmail.net>...
> How much storage difference is there between defining a column numeric
> vs. numeric (X).
>
> I find that restricting the length of the field in most cases causes
> more development pains than allowing unrestricted lengths.
>
> TIA,
>
> Kevin
>
>
Received on Thu May 14 1998 - 02:47:47 CDT
