title: What is maximum Scale for the decimal.
body: <p>What is maximum Scale  for the decimal. I know that the Legal values for precision range from 1 to 38, and legal values for scale range from -84 to 127.
  In other words, how can we give 127  or -84 in the scale  value ?
  For example :
  select  cast (12345678912345678912345678912.123456789  AS decimal(38,9)) from dual;</p>
  
  <p>I cannot give more than 9 scale. Even If i place my decimal at any postion I cannot give more than 38 (may be less) so how come scale ranges from -84 to 127.</p>
  
  <p>Can anyone quote example for maximum scale ?
  Note: this question is database independent. </p>
  
  <p>Thanks in advance.</p>