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 -> Re: How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?

Re: How many pre-decimal positions/integer digits has a DECimal (5,3) defined field ?

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 8 Oct 2004 14:15:13 -0700
Message-ID: <336da121.0410081315.3f028531@posting.google.com> 





peterb_at_gmx.net (Peter Blatt) wrote in message news:<ck4ale$n5t$00$1_at_news.t-online.com>...


> Does 5 represent the total numer of digits (including the fractional portion) or only the number of places

> BEFORE the decimal point? Moreover does the number include the decimal point?

> 

> Are there differences between the databases servers ?

> 

> Peter




In Oracle:



5 represents total number of decimal digits, not including decimal point.
Received on Fri Oct 08 2004 - 16:15:13 CDT












Original text of this message













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