precision & scale
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: precision & scale

  1. #1
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Hi

    Does anyone know what is the precision of scale if we create a table with column number without specifying number(x,y)? Just use for exmaple

    empno number,

    cheers

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check out the NUMBER under the link:

    http://technet.oracle.com/doc/oracle...ch23.htm#37627

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    NUMBER
    is a floating-point number with decimal precision 38. Note that a scale value is not applicable for floating-point numbers. (See "Floating-Point Numbers" for more information.)


    so I guess itīs number(38, 0)?

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    No, if it were number(38, 0) then anything right from the decimal point would be lost! When specifying datatype simply as NUMBER it means that the precision is limited by maximum allowable precision (38 digits), while scale is unconstrained, meaning you can use any scale for that precision. That's why it is said that scale is not applicable for floating point numbers.

    HTH,
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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