GaussDB->Oracle
|
Data Type (GaussDB) |
Data Type (Oracle) |
Whether to Support Mapping |
|---|---|---|
|
TINYINT |
NUMBER |
Yes |
|
SMALLINT |
NUMBER |
Yes |
|
INTEGER |
NUMBER |
Yes |
|
BIGINT |
NUMBER |
Yes |
|
NUMBER |
NUMBER |
Yes |
|
NUMERIC |
NUMBER |
Yes |
|
REAL |
BINARY_FLOAT |
Yes |
|
DOUBLE PRECISION |
BINARY_DOUBLE |
Yes |
|
DATE |
DATE |
Yes |
|
BOOLEAN |
CHAR(1) |
Yes |
|
CHARACTER |
CHAR |
Yes |
|
CHARACTER VARYING |
VARCHAR2 |
Yes |
|
NVARCHAR2 |
NVARCHAR2 |
Yes |
|
TEXT |
CLOB |
Yes |
|
BLOB |
BLOB |
Yes |
|
BYTEA |
BLOB |
Yes |
|
TIMESTAMP WITHOUT TIME ZONE |
TIMESTAMP |
Yes |
|
TIMESTAMP WITH TIME ZONE |
TIMESTAMP WITH TIME ZONE |
Yes |
|
TIME WITHOUT TIME ZONE |
VARCHAR2(32) |
Yes |
|
TIME WITH TIME ZONE |
VARCHAR2(32) |
Yes |
|
CLOB |
CLOB |
Yes |
|
RAW |
RAW |
Yes |
|
MONEY |
VARCHAR2 |
Yes |
|
TINYINT UNSIGNED |
NUMBER |
Yes |
|
SMALLINT UNSIGNED |
NUMBER |
Yes |
|
INTEGER UNSIGNED |
NUMBER |
Yes |
|
BIGINT UNSIGNED |
NUMBER |
Yes |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.