Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

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

Posted on 2008-06-13
3
Medium Priority
?
577 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
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 1000 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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses
Course of the Month11 days, 4 hours left to enroll

572 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