Convert XML table into SQL table
878240May 17 2012 — edited May 26 2012I'm looking for an easy way to convert an XML table into a SQL table. I've created a schema and the table, with the XDB SQLType annotations to define complex types and the SQLName annotations for element names. The Oracle types that were defined in the schema have been created, but when I select from DBA_XML_TAB_COLS there are no columns. How can I get the SQL table structure from the XML table?
Thank you.