# precision & scale

Printable View

• 05-03-2001, 12:54 PM
pando
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
• 05-03-2001, 01:03 PM
sambavan
Check out the NUMBER under the link:

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

Sam
• 05-03-2001, 01:06 PM
pando
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)?
• 05-03-2001, 02:46 PM
jmodic
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,