Which one is better to use ?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Which one is better to use ?

  1. #1
    Join Date
    Oct 2002

    Which one is better to use ?

    Hello all..

    I have a dilema here. I am on Oracle 92.

    When i create a field in a table that is going to use NUMBER data, which one can i use ?..i read some where that NUMBER datatype can hold both INTEGER and DECIMAL types..is it true ?..

    or should i use NUMBER (p,s) for Decimals and just NUMBER for INTEGERS ?...


  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    Depends on what numbers you want to store -- if you need decimal places, then specify them.

    The precision and scale are simply check constraints that restrict the maximum p & s that the column will store. It makes no difference to how many bytes are used for storage.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width