I need to generate xml schema to be used in XMLDB.Im having XML document.how to generate schema file(xsd) in oracle 10g...I googled and found oracles "DBMS_XMLSCHEMA.GENERATESCHEMA"..but i couldnt understand better as im new to this..I have loaded my xml in oracle...can someone pls help on this ???
DBMS_XMLSCHEMA.GENERATESCHEMA works on a set of existing SQL object types and/or collections, it builds the schema out of this structure and maps SQL datatypes to XML datatypes.
If all the input you have is an XML instance document, that won't help you.
You'll need a 3rd party tool supporting schema inference, e.g. XMLSpy or Oxygen (not free), or MS XML Schema Definition Tool (part of the .NET SDK), or another free online converter.