...
Oracle Data Type | CDAP Schema Data Type | Support | Comment |
---|---|---|---|
VARCHAR2 | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default |
NVARCHAR2 | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default |
VARCHAR | Schema.Type.STRING | + | |
NUMBER | Schema.LogicalType.DECIMAL | + | |
FLOAT | Schema.Type.DOUBLE | + | FLOAT(126) by default value is represented internally as NUMBER |
LONG | Schema.Type.LONGSTRING | + | Character data of variable length. |
DATE | Schema.LogicalType.DATE | + | |
BINARY_FLOAT | Schema.Type.FLOAT | + | |
BINARY_DOUBLE | Schema.Type.DOUBLE | + | |
TIMESTAMP | Schema.LogicalType.TIMESTAMP_MICROS | + | |
TIMESTAMP WITH TIME ZONE | Schema.LogicalType.TIMESTAMP_MICROS | + | |
TIMESTAMP WITH LOCAL TIME ZONE | Schema.LogicalType.TIMESTAMP_MICROS | + | |
INTERVAL YEAR TO MONTH | Schema.Type.STRING | + | |
INTERVAL DAY TO SECOND | Schema.Type.STRING | + | |
RAW | Schema.Type.BYTES | + | |
LONG RAW | - | Type is deprecated by Oracle | |
ROWID | Schema.Type.STRING | + | |
UROWID | Schema.Type.STRING | * | No such type in java.sql.Types, mapping to String by default |
CHAR | Schema.Type.STRING | + | |
NCHAR | Schema.Type.STRING | + | |
CLOB | Schema.Type.STRING | + | |
NCLOB | Schema.Type.STRING | + | |
BLOB | Schema.Type.BYTES | + | |
BFILE | - | Type is deprecated by Oracle |
...