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
    Posts
    284

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

    Thanks
    Ron

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    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