Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: number vs. number(4)
Unqualified number fields are up to 38 digits in length (and hence approximately 38 bytes variable), and qualified ones are up to the qualifier in length. It comes down, in the end, to saving space within the row.
Regards
HJR
<berj_kacherian_not_at_hotmail.com> wrote in message
news:94la6b$v4j$1_at_nnrp1.deja.com...
> While creating a table you may choose to specify the length of a
> numeric column or you may choose to not specify it.
>
> What is the difference between
>
> number
>
> and
>
> number(4)
>
> What are the advantages or disadvantages of using one or the other?
>
>
> --
> Out the Ethernet, past the firewall, through the router, down the
> T1...nothing but Net
>
> In order to email me remove the '_not' from my email address.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Tue Jan 23 2001 - 19:38:31 CST