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: export the result to a text file

Re: export the result to a text file

From: Frank Seuberth <frank.seuberth_at_odn.de>
Date: Mon, 22 Oct 2001 09:20:14 +0200
Message-ID: <3BD3C8AE.24B3A7B6@odn.de> 





WKC wrote:


> 

> In sqlplus, how can i export the result to a text file from a sql statment?




Just doo



spool  drive:pathlist:filname



at the end 


spool off



There are some more usefull keywords when you do this.



Linesize


pagesize


heading



Just look in the Online Docu



Frank
Received on Mon Oct 22 2001 - 02:20:14 CDT












Original text of this message













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