Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Convert XML table into SQL table

878240May 17 2012 — edited May 26 2012
I'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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 23 2012
Added on May 17 2012
8 comments
903 views