DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Number datatype

  1. 12-14-2000, 05:10 PM #1
    mehak
    mehak is offline Junior Member
    Join Date
    Dec 2000
    Posts
    62
    How much space does Oracle allocate on a column if the datatype is number and no precision/scale is specified?
    Reply With Quote Reply With Quote
  2. 12-14-2000, 06:40 PM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The data type number has precision and scale. the precision can range from 1-38 and the scale can range from -84 to 127. If no specification was made, then oracle would allocate 4bytes for number.

    Hope this would answer your question.
    Sam
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width