Which datatypes can be compared?
Published 24 February 2022
Data Compare for Oracle supports comparison and deployment of the following datatypes:
- CHAR
- VARCHAR2
- NCHAR
- NVARCHAR2
- NUMBER
- FLOAT
- BINARY_FLOAT
- BINARY_DOUBLE
- RAW
- LONG RAW
- DATE
- TIMESTAMP
- TIMESTAMP WITH TIME ZONE
- TIMESTAMP WITH LOCAL TIME ZONE
- INTERVAL YEAR TO MONTH
- INTERVAL DAY TO SECOND
- BLOB
- CLOB
- NCLOB
- ROWID
- UROWID
- XMLTYPE
Datatypes not in this list don't appear in comparison results, and can't be deployed.
