Re: NUMBER Datatype

From: John Chiu <johnymc_at_netscape.net>
Date: Tue, 16 Nov 1999 05:56:05 -0500
Message-ID: <80rd5k$36o$1@news2.tor.accglobal.net>

Do you mean the default value of NUMBER(precision,scale)?

there is no default value. The maximum precision is 38 and the scale ranges from -84 to 127.

I found the default precision/scale not the same when a column is defined as FLOAT instead of NUMBER.
I forgot the exact scale FLOAT used, it is about 6 or 7 decimal places.

John Chiu

<www_dba_at_my-deja.com> wrote in message news:80r3cq$g5f$1_at_nnrp1.deja.com...
> Hi,
>
> When creating tables, if precision is not specified to a NUMBER column.
> What will be the default value?
>
> Thanks.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 16 1999 - 04:56:05 CST