虚谷数据库与Oracle类型映射
| Oracle数据类型 | Xugu数据类型 |
|---|---|
| BFILE | BLOB |
| BINARY_DOUBLE | DOUBLE |
| BINARY_FLOAT | DOUBLE |
| BLOB | BLOB |
| CLOB/NCLOB | CLOB |
| CHAR/NCHAR | CHAR |
| DATE | DATETIME |
| DECIMAL (NUMBER(38)) | NUMERIC |
| DOUBLE PRECISION (FLOAT(126)) | DOUBLE |
| FLOAT | FLOAT |
| INTEGER (NUMBER(38)) | NUMERIC |
| INTERVAL DAY TO SECOND | INTERVAL DAY TO SECOND |
| INTERVAL YEAR TO MONTH | INTERVAL YEAR TO MONTH |
| NUMBER/NUMERIC | NUMERIC |
| RAW | BINARY |
| REAL (FLOAT(63)) | DOUBLE |
| SMALLINT (NUMBER(38)) | NUMERIC |
| TABLE (RAW(16)) | BINARY |
| TIMESTAMP （TIMESTAMP(6)） | DATETIME |
| UROWID | CHAR |
| VARCHAR2/VARCHAR/NVARCHAR2 | VARCHAR |
| TIMESTAMP WITH TIME ZONE | DATETIME WITH TIME ZONE |
| TIMESTAMP WITH LOCAL TIME ZONE | DATETIME WITH TIME ZONE |
| ROWID | CHAR |
| LONG | CLOB |
| LONG RAW | BLOB |