Generate XML Schemas for your Data

A reader recently asked:


We are using Oracle eBS and 9i (XML DB not installed), and need to generate XSDs from the client site using SQLPlus. DTDs are currently generated from the client: the SQLPlus script calls a database package that creates a bunch of DTDs from a table that describes all parameters/tags of the XML in a manager-to-employee-nested way. Now, instead of changing the source (1 gazillion lines of code..) to a produce XSD syntax, I guess t