Default format?

  • Lynn Pettis

    SSC Guru

    Points: 442091

    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: 95327

    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[/url]


    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[/url], How to ask a question, Performance Problems[/url], Common date/time routines,
    CROSS-TABS and PIVOT tables Part 1[/url] & [url url=http://www

  • Lynn Pettis

    SSC Guru

    Points: 442091

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply