Default reverse data type mappings for Oracle NET8 data sources

The following table lists the default reverse data type mappings for Oracle NET8 data sources.

Table 1. Oracle NET8 default reverse data type mappings
Federated Typename Federated Lower Len Federated Upper Len Federated Lower Scale Federated Upper Scale Federated Bit Data Federated Data Operators Remote Typename Remote Length Remote Scale Remote Bit Data

BIGINT

 0 8 0 0 N \0 NUMBER 19 0 N
BLOB 0 2147483647 0 0 Y \0 BLOB 0 0 Y
CHARACTER 1 254 0 0 N \0 CHAR 0 0 N
CHARACTER 1 254 0 0 Y \0 RAW 0 0 Y
CLOB 0 2147483647 0 0 N \0 CLOB 0 0 N
DATE1 0 4 0 0 N \0 DATE 0 0 N
DECIMAL 0 0 0 0 N \0 NUMBER 0 0 N
DECFLOAT 0 8 0 0 N \0 NUMBER 0 0 N
DECFLOAT 0 16 0 0 N \0 NUMBER 0 0 N
DOUBLE 0 8 0 0 N \0 FLOAT 126 0 N
FLOAT 0 8 0 0 N \0 FLOAT 126 0 N
INTEGER 0 4 0 0 N \0 NUMBER 10 0 N
REAL 0 4 0 0 N \0 FLOAT 63 0 N
SMALLINT 0 2 0 0 N \0 NUMBER 5 0 N
TIME 0 3 0 0 N \0 DATE 0 0 N
TIMESTAMP 2 0 10 0 0 N \0 DATE 0 0 N
TIMESTAMP(p) 3 - - - - N \0 TIMESTAMP(p) - - N
VARCHAR 1 4000 0 0 N \0 VARCHAR2 0 0 N
VARCHAR 1 2000 0 0 Y \0 RAW 0 0 Y
Note:
  1. When the date_compat parameter is set to OFF, the federated DATE maps to the Oracle date. When the date_compat parameter is set to ON, the federated DATE (equivalent to TIMESTAMP(0)), maps to Oracle TIMESTAMP(0).
  2. This type mapping is valid only with Oracle Version 8.
    • TIMESTAMP(p) represents a timestamp with a variable scale from 0-9 for Oracle and 0-12 for federation. When the scale is 0-9, the remote Oracle TIMESTAMP has the same scale as the federated TIMESTAMP. If the scale of the federated TIMESTAMP is greater than 9, the corresponding scale of the Oracle TIMESTAMP is 9 which is the largest Oracle scale.
    • This type mapping is valid only with Oracle Version 9, 10, and 11.