Sybase IQ to Oracle Data Type Mappings
When you use a CREATE TABLE statement to create a remote table on an Oracle server, Sybase IQ converts the IQ data types to corresponding Oracle data types:
Oracle to Sybase IQ Data Mappings
When you use a CREATE EXISTING statement to create a proxy table to an existing Oracle table, IQ converts the Oracle data types to corresponding IQ data types.