将Oracle迁移到TeleDB Oracle TeleDBX 数值类型 数值类型 NUMBER(p,s) s!0 numeric/decimal NUMBER(p,s) s0,1 < p < 4 int2 NUMBER(p,s) s0,5 < p < 9 int4 NUMBER(p,s) s0,10 < p < 19 int8 FLOAT real/float4 BINARYFLOAT real/float4 REAL real/float4 BINARYDOUBLE double precision/float8 时间类型 DATE timestamp TIMESTAMP timestamp TIMESTAMP WITH TIME ZONE timestamptz TIMESTAMP WITH LOCAL TIME ZONE timestamptz 字符类型 CHAR char/bpchar NCHAR char/bpchar VARCHAR varchar VARCHAR2 varchar NVARCHAR2 varchar ROWID varchar BLOB bytea RAW bytea LONGRAW bytea CLOB text NCLOB text LONG text 时间间隔类型 INTERVAL YEAR TO MONTH interval INTERVAL DAY TO SECOND interval 以下类型未考虑支持 BFILE、ROWID、UROWID、XMLTYPE 、SDOGEOMETRY