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: Dumping table into ascii delimited file?

Re: Dumping table into ascii delimited file?

From: William Dangren <wdangren_at_navisent.com>
Date: Thu, 29 Jul 1999 18:13:05 -0400
Message-ID: <37A0D1F1.F040B578@navisent.com> 





Yes, you can spool the output to a file.  here is an example:



SQL>spool c:\output\comma_file.txt


SQL>select ''|| username || ',' || user_id ||'' from dba_users;



Bill



--


William Dangren


Navis Enterprises


407.348.6401


800.219.0207


Received on Thu Jul 29 1999 - 17:13:05 CDT












Original text of this message













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