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: How to make an ASCII file?

Re: How to make an ASCII file?

From: David Irving <dirving_at_denr.sa.gov.au>
Date: 1997/08/27
Message-ID: <3403B55E.A39@denr.sa.gov.au>#1/1

something like
  spool out.lst;
  select * from table;
  spool off;
would do it: inelegant but effective. there are various sql*plus commands you can use to get rid of the column headings and tidy the output up a bit.

regards,
david

Peter Schneider wrote:
>
> Hello everybody!
>
> I need to convert my ORACLE database file into an ASCII or text file!
> How can I do this?
>
> Thanks in advance
> Peter
>
Received on Wed Aug 27 1997 - 00:00:00 CDT

Original text of this message

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