How to generate XML file and save in Oracle Directory

Method 1
~~~~~~~~~

declare
        refc sys_refcursor;
        xdoc DBMS_XMLDOM.DOMDocument;
begin
   open refc for
      select rownum from dual connect by level < 10 ;
      xdoc := DBMS_XMLDOM.NewDOMDocument(xmltype( refc ));
      DBMS_XMLDOM.WRITETOFILE(xdoc, 'XML_DOCS/xml1.xml');
end;

Method 2
~~~~~~~~~

declare
 refc  sys_refcursor;
 BEGIN
   open refc FOR
      SELECT rownum FROM dual connect BY level < 10 ;
 dbms_xslprocessor.clob2file( xmltype( refc ).getclobval( ) , 'XML_DOCS','xml11.xml');
 END;
/