Category Archives: oracle

Generate XML Schema from oracle tables

Posted on August 26, 2010 by Jianming Li

Here is a nice thread describing how to generate XML schema from Oracle tables. I tried the following function and it worked great. * Compile the following PL/SQL function: CREATE OR REPLACE FUNCTION GEN_XML_SCHEMA(target_table varchar2) RETURN xmltype AS xmlSchema XMLTYPE; … Continue reading →

Posted in oracle | Leave a comment