Solved

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

Posted on 2008-06-13
3
570 Views
Last Modified: 2013-12-19
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
Comment
Question by:rutgermons
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 21782550

You could use the UTL_FILE package.
0
 

Author Comment

by:rutgermons
ID: 21782673
have u got an example?

r
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question