<div>
have u got an example?<br />
<br />
r
</div>


<div>
<div class="content wysiwyg-content">
folks<br />
how can I export this following query using the DBMS_XMLGEN.GETXML function to a file in my C:\temp drive<br />
<br />
Select DBMS_XMLGEN.GETXML (<br />
&nbsp; &nbsp; &nbsp; 'select WORKORDER.wonum,ASSET.ASSE<wbr />TNUM,WORKO<wbr />RDER.DESCR<wbr />IPTION,<br />
&nbsp; &nbsp; &nbsp; (SELECT LOCATIONS.LOCATION FROM LOCATIONS WHERE WORKORDER.LOCATION=LOCATIO<wbr />NS.LOCATIO<wbr />N)AS GG<br />
&nbsp; &nbsp; &nbsp; from workorder,ASSET<br />
&nbsp; &nbsp; &nbsp;where WORKORDER.ASSETNUM=ASSET.A<wbr />SSETNUM AND WORKORDER.status =''COMP'' AND<br />
&nbsp; &nbsp; WORKORDER.WORKTYPE=''PM'''<wbr />)<br />
&nbsp; from dual;<br />
<br />
all help will do
</div>
</div>


folks
how can I export this following query using the DBMS_XMLGEN.GETXML function to a file in my C:\temp drive

Select DBMS_XMLGEN.GETXML (
      'select WORKORDER.wonum,ASSET.ASSETNUM,WORKORDER.DESCRIPTION,
      (SELECT LOCATIONS.LOCATION FROM LOCATIONS WHERE WORKORDER.LOCATION=LOCATIONS.LOCATION)AS GG
      from workorder,ASSET
     where WORKORDER.ASSETNUM=ASSET.ASSETNUM AND WORKORDER.status =''COMP'' AND
    WORKORDER.WORKTYPE=''PM''')
  from dual;

all help will do

oracle, database, 10, exporting to xml -export to file

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.