Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Constrainting NUMBER

Constrainting NUMBER

From: as <none_at_asgmeail.com>
Date: Thu, 26 May 2005 08:08:51 +0800
Message-ID: <429513ba$1_1@rain.i-cable.com>


Is it good to leave all numeric columns as NUMBER instead of specifying a precision, say, NUMBER(6,2).

What are the pros and cons of the two approaches? At least, it seems that using NUMBER for everything simplified code modification in case we need to change the required precision. Received on Wed May 25 2005 - 19:08:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US