OraFAQ Forum: SQL & PL/SQL » Data Type Number

Home » SQL & PL/SQL » SQL & PL/SQL » Data Type Number (Oracle 11g )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Data Type Number [message #612553]

Mon, 21 April 2014 22:36

teck_lee80@yahoo.com
Messages: 3
Registered: April 2014

Junior Member

Hi All,

I would like to know what is the max precision and scale for Data Type Number without precision and scale ?
When i try to insert dummy data for testing, i get the following result.

The Column ID is data type Number without Precision and Scale. I couldn't make a summary on what is the max length for precision and scale can reach in Oracle.

Hope anyone could help ..

Thanks..

Attachment: oracle.PNG
(Size: 13.81KB, Downloaded 562 times)

Report message to a moderator

Re: Data Type Number [message #612554 is a reply to message #612553]

Mon, 21 April 2014 23:40

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

It's well explained in documentation here http://docs.oracle.com/cd/B28359_01/server.111/b28318/datatype.htm#i22289

You can enter 38 digits in NUMBER column.

Report message to a moderator

Re: Data Type Number [message #612555 is a reply to message #612554]

Tue, 22 April 2014 00:47

teck_lee80@yahoo.com
Messages: 3
Registered: April 2014

Junior Member

Thanks for quick reply..
If based on the attached image in previous post, the digit is definitely more than 38 digits.
This is what make me curious on actual length and size for Data Type Number without precision and scale.

Thanks.

Report message to a moderator

Re: Data Type Number [message #612556 is a reply to message #612555]

Tue, 22 April 2014 01:07

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is 38 significant digits, right 0 before decimal point are not part of these digits.

Report message to a moderator

Re: Data Type Number [message #612560 is a reply to message #612556]

Tue, 22 April 2014 01:24

teck_lee80@yahoo.com
Messages: 3
Registered: April 2014

Junior Member

Hi Michael,

See the attached image, the input highlighted in red are greater than 38 digit before decimal.

Sad

Thanks.

Attachment: oracle.PNG
(Size: 11.56KB, Downloaded 568 times)

Report message to a moderator

Re: Data Type Number [message #612564 is a reply to message #612560]

Tue, 22 April 2014 01:36

Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

As I said, you must not count the 0 at the right.

Report message to a moderator

Previous Topic:	How to join two table with no duplicate
Next Topic:	join field depending on condition

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 16:01:02 CDT 2024