XML schema to generate tables/columns in Oracle 9iR2

Dear Readers,

I am a beginner with oracle and having fun figuring things out.

I have .xsd documents (xml schema) with include statements upto 3 levels of more. file1.xsd has include statement for file-11.xsd; file-11.xsd has an include for file-111.xsd.

can i take all those files and run them against the XML DB in oracle 9iR2 and get them to generate tables and columns or am i talking through my hat. if i can get tables and columns, then i can write pl/sql packages to get data from the production database in a totally different table/column structure.

Let me reword the problem is simpler terms:

we have a production database designed 6 yeards back. i want to transfer data to EPA (environmental protection agency) in their XML format. i also want to show the data on the internet for 'authorized' users. if i use XML, then i can use appropriate XSLT to show the data on the web etc.

then i can also exchange xml data in the epa .xsd format with other 'authorized' agencies. that is why i am rushing to the xml way.

thanks and regards
Ravi. Received on Tue Mar 11 2003 - 10:24:22 CST