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

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie question - Exporting a query into a text file

Re: newbie question - Exporting a query into a text file

From: Jason Judge <jason.judge_at_virgin.net>
Date: Wed, 23 Jun 1999 23:59:57 +0100
Message-ID: <7kroln$2qe$2@nclient3-gui.server.virgin.net> 





Use SQL*Plus with the spool command:



set head off


set feedback off


set pagesize 0


set trimout on


set trimspool on


spool myfile.txt


select name || ',' || address from details;
spool off



Phong Lam wrote in message <377154F1.69337020_at_us.ibm.com>...


>Is it possible to run a query in Oracle and then dump it into a flat


>text file?  I'm running 7.3.4


>


>Thanks


>




Received on Wed Jun 23 1999 - 17:59:57 CDT












Original text of this message













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