Write PL/SQL query results to a file

From: robert <shhmoo_at_excite.com>
Date: 18 Jun 2003 08:16:31 -0700
Message-ID: <114e40a3.0306180716.5aa0b4b8_at_posting.google.com>

I'm trying to write the results of my PL/SQL query to a file. I have came across a number of possible* solutions such as DBMS_PIPE and UTL_FILE. Basically, I am running a batch file on an NT box and would like to obtain the results from the DB server running Oracle 8.1.7.4.0.

So far I have been able to get export a file to my local machine by doing:
exp 'usr/passwd _at_db' full=no file=%ORACLE_SID%.dmp %ORACLE_SID%.log

I would like to have this file be the output of my query instead. Any info appreciated. Thanks in advance. Received on Wed Jun 18 2003 - 17:16:31 CEST

This message: [ Message body ]
Next message: Upendra Mishra: "Uploading file"
Previous message: Linus Nikander: "Easiest way to transfer data from Oracle to SQL Server using a file."
Next in thread: Rauf Sarwar: "Re: Write PL/SQL query results to a file"
Reply: Rauf Sarwar: "Re: Write PL/SQL query results to a file"
Reply: Martin Burbridge: "Re: Write PL/SQL query results to a file"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message