Data Compare for Oracle 2

Which datatypes can be compared?

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.

Didn't find what you were looking for?