Contents Index ROW_COUNTS option [database] SORT_COLLATION option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

SCALE option [database]


Function 

Specifies the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION.

Allowed values 

Integer, between 0 and 127 inclusive.

Scope 

Can be set for an individual connection or for the PUBLIC group. Takes effect immediately.

Default 

6

Description 

Multiplication, division, addition, subtraction, and aggregate functions can all have results that exceed the maximum precision. See PRECISION option [database] for an example.


Contents Index ROW_COUNTS option [database] SORT_COLLATION option [database]