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
