comparing SQL from 2 different database vendors

[MurraySobol]

I am comparing SQL between 2 different Database vendors: Oracle and SQL Anywhere.
Here is a sample: see attached.
The left side is Oracle SQL, the right side is SQL Anywhere.
How do I make a rule that says Oracle datatype "number" is equivalent to SQL Anywhere datatype "integer"?
Thanks
Murray

[Aaron]

There are a couple of methods.

If you have Pro edition, you can go to the Session menu -> Session Settings, Replacements tab, and define "number" = "integer" for this view or a default for all future Text Compare views. This would apply regardless of file type.

The File Format can be specific to file type, but is defined as Oracle "Number" is Unimportant and SQL "integer" as Unimportant whether they align to each other or to something else; any difference would be Unimportant (although the other side would be Important if it is different, important text).
http://www.scootersoftware.com/suppo..._unimportantv3