Page 1 of 1

precision allowed in decimal datatype

Posted: Sat Mar 12, 2011 6:17 pm
by harryhome
have source with number datatype with data 18 decimal place after decimal point.

in server we have limit of 15 precision in decimal datatype

same is the case with parallel?

Posted: Sat Mar 12, 2011 6:38 pm
by chulett
That's not a "hard limit", more of a soft one in Server as 15 just happens to be the default value for precision in the configuration file. And "after the decimal point" would be scale not precision.

Have you tried it? Had any problems with it?