Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: creating output file from sqlplus
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
![]() |
![]() |