Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!news.cs.univ-paris8.fr!proxad.net!216.239.36.134.MISMATCH!postnews.google.com!v45g2000cwv.googlegroups.com!not-for-mail
From: muralidhargvn@hotmail.com
Newsgroups: comp.databases.oracle.misc
Subject: Number Data Type
Date: 2 Feb 2007 05:21:08 -0800
Organization: http://groups.google.com
Lines: 16
Message-ID: <1170422468.157057.306180@v45g2000cwv.googlegroups.com>
NNTP-Posting-Host: 210.214.208.16
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1170422473 22716 127.0.0.1 (2 Feb 2007 13:21:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 2 Feb 2007 13:21:13 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: v45g2000cwv.googlegroups.com; posting-host=210.214.208.16;
   posting-account=ozvVdQ0AAACmEKBP4a6BFKb46aj9TIz8
Xref: news.f.de.plusline.net comp.databases.oracle.misc:77894

Hi All,

I am using Oracle 10g database.
I have a table with field name "Amount" and its datatype is
Number(7,2).
If I enter the amount value as 10.23, it is stored beautifully in the
database.
But, if I enter the amount value as 10.00, it is getting truncated and
stored in the databse as only 10 (The decimal part is not stored in
the database if both the digits in the decimal part are zeros')

Can any one help me in understanding this, and how to over come this?

Thanks in advance,
Murali.