Default format?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 3, 2010 at 9:44 am

  #242604

  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).

• WayneS

  SSC Guru

  Points: 95460

  More actions

  November 3, 2010 at 10:13 am

  #1246141

  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

  ---

  If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!

  ---

  Links:
  For better assistance in answering your questions
  Performance Problems
  Common date/time routines
  Understanding and Using APPLY Part 1 & Part 2

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  November 3, 2010 at 10:14 am

  #1246142

  Okay, finally found it in the documentation. A column defined as a NUMBER is a FLOAT. Okay, that really makes sense, doesn't it.