Re: NUMBER vs NUMBER (n)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 30 Sep 2006 07:58:45 +0200
Message-ID: <br1sh210pvutoap4a5vehd1k2gka2i2t1g@4ax.com>

On 29 Sep 2006 17:14:01 -0700, krislioe_at_gmail.com wrote:

>Hi all,
>
>I have some basic oracle question :
>
>1) When do we use NUMBER and NUMBER (n) ?
>
>2) For surrogate key, is it better to use INTEGER, or NUMBER or NUMBER
>(n) ? why ?
>
>Thank you,
>xtanto

2 Number(10) will usually work just fine, as that allowes you to store a 8-bit integer.

--
Sybrand Bakker, Senior Oracle DBA

Received on Sat Sep 30 2006 - 00:58:45 CDT