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
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.
WayneMicrosoft Certified Master: SQL Server 2008Author - 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