Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: creating output file from sqlplus

Re: creating output file from sqlplus

From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Sep 2005 16:22:33 -0700
Message-ID: <1125703306.229984@yasure>


DH wrote:
> I know how to use the spool command in sql*plus to save the results to a
> file. But myquery is returning about 63,000 user IDs. I need these in a
> text output file that can be imported into a utility to correct a problem
> we're having. Using the spool command includes line numbers and headers
> that would have to be stripped out manually. Is there a way to create a
> file with simply the user IDs?
>
> (Hope this is the right group to post this - I couldn't find one for
> sql*plus)

Write a cleaner SQL statement with the appropriate SQL*Plus commands such as those TRIMSPOOL and HEADER OFF, etc. All documented at www.psoug.org
click on Morgan's Library
click on SQL*Plus

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Fri Sep 02 2005 - 18:22:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US