Regarding Numer(p,s)

From: Udhaya <uuk007_at_gmail.com>
Date: 4 Jul 2006 12:23:46 -0700
Message-ID: <1152041026.433000.158750@m73g2000cwd.googlegroups.com>

Dear All,

As per Oracle document in Number(p,s)

P is the total number of digits which range from 1 to 38 and

S is Scale which range from -84 to 127

Number (7,2) mean total number of digits is 7 and i can have 2 digits eight to the decimal.

Then how can i use the maximum range like Number(38,127)

which means i can have totally 38 digits and 127 digits right to the decimal..

I think i am missing the Flaoting Pint algoritham...

Please let me clear this..

Regards

Udhaya Received on Tue Jul 04 2006 - 14:23:46 CDT