Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 580
  • Last Modified:

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

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
0
rutgermons
Asked:
rutgermons
1 Solution
 
MikeOM_DBACommented:

You could use the UTL_FILE package.
0
 
rutgermonsAuthor Commented:
have u got an example?

r
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now