ORNUMERIC= Table Option

Specifies how numbers read from or inserted into the Oracle NUMBER column are treated.

Category: Table Control
Default: YES
Data source: Oracle
Data type: DECIMAL, NUMERIC

Syntax

ORNUMERIC=YES | NO

Arguments

NO

Indicates that the numbers are treated as TKTS_DOUBLE values. They might not have precision beyond 14 digits.

YES

Indicates that non-integer values with explicit precision are treated as TKTS_NUMERIC values. This is the default setting.

Details

This option defaults to YES so that a NUMBER column with precision or scale is described as TKTS_NUMERIC. This option can be specified as both a connection option and a table option. When specified as both connection and table option, the table option value overrides the connection option.