Home » SQL & PL/SQL » SQL & PL/SQL » Data Type Number (Oracle 11g )
Data Type Number [message #612553] Mon, 21 April 2014 22:36 Go to next message
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 51 times)
Re: Data Type Number [message #612554 is a reply to message #612553] Mon, 21 April 2014 23:40 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2544
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.
Re: Data Type Number [message #612555 is a reply to message #612554] Tue, 22 April 2014 00:47 Go to previous messageGo to next message
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.
Re: Data Type Number [message #612556 is a reply to message #612555] Tue, 22 April 2014 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 60060
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.

Re: Data Type Number [message #612560 is a reply to message #612556] Tue, 22 April 2014 01:24 Go to previous messageGo to next message
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 50 times)
Re: Data Type Number [message #612564 is a reply to message #612560] Tue, 22 April 2014 01:36 Go to previous message
Michel Cadot
Messages: 60060
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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


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


Current Time: Fri Dec 26 07:00:00 CST 2014

Total time taken to generate the page: 0.11424 seconds