Databases Reference
In-Depth Information
Verifying the result
We have now completed our mapping and can verify what has been done by looking
at the generated XML Schema file. Note that the generated schema uses some Oracle
extensions to enable a non-XML formatted file to be represented as XML. In particular
the
NXSD
namespace prefix is used to identify field separators and record terminators.
The XML Schema generated can be edited manually. This is useful to
support nested records (records inside other records) like those that may
be found in a file containing order records with nested detail records (an
order record contains multiple line item detail records). In this case, it
is useful to use the wizard to generate a schema with order records and
detail records at the same level. The schema can then be modified by
hand to make the detail records children of the order records.
