Altova XMLSpy 2024 Enterprise Edition

When an XML Schema is generated from an Oracle database (DB), the Oracle DB datatypes are converted to XML Schema datatypes as listed in the table below.

 

Oracle Datatype

XML Schema Datatype

ROWID

xs:ID

CHAR

xs:string

NCHAR

xs:string

VARCHAR2

xs:string

NVARCHAR2

xs:string

CLOB

xs:string

NCLOB

xs:string

NUMBER (with check constraint applied)*

xs:boolean

NUMBER

xs:decimal

FLOAT

xs:double

DATE

xs:dateTime

INTERVAL YEAR TO MONTH

xs:gYearMonth

BLOB

xs:base64Binary

 

* If a check constraint is applied to a column of datatype NUMBER, and the check constraint checks for the values 0 or 1, then the NUMBER datatype for this column will be converted to an XML Schema datatype of xs:boolean. This mechanism is useful for generating an xs:boolean datatype in the generated XML Schema.

 

© 2017-2023 Altova GmbH