November 3, 2010 at 9:44 am
In Oracle, if a column is declare as a NUMBER with no precison or scale, what is the default? The documentation I have doesn't seem to indicate it (or else I just can't find where it is defined).
November 3, 2010 at 10:13 am
http://www.devarticles.com/c/a/Oracle/Datatypes-Used-in-Oracle-9i/1/
A NUMBER datatype with no parameters is set to its maximum size.
Edit: Found another site that says if precision isn't specify, then 38 is used.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
November 3, 2010 at 10:14 am
Okay, finally found it in the documentation. A column defined as a NUMBER is a FLOAT. Okay, that really makes sense, doesn't it.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy