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 -> creating output file from sqlplus

creating output file from sqlplus

From: DH <my_generic_email_at_att.net>
Date: Fri, 02 Sep 2005 22:08:21 GMT
Message-ID: <p34Se.3417$qY1.1453@bgtnsc04-news.ops.worldnet.att.net>


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

Original text of this message

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