Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> creating output file from sqlplus
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) Received on Fri Sep 02 2005 - 17:08:21 CDT
![]() |
![]() |