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 -> Re: Q:Save a Table on ASCII file

Re: Q:Save a Table on ASCII file

From: Gary M. Greenberg <garyg_at_southeast.net>
Date: 1997/02/15
Message-ID: <garyg-ya02408000R1502971524380001@news.southeast.net>#1/1

In article <3305B082.6ED6_at_grn.es>, pjuanola_at_grn.es wrote:

    [posted && mailed]
> Does anybody knows how to save a table in an ASCII file ?

Do you mean output the contents of some table into an ascii file?

set termout off
spool <table>.lst
describe <table> /* for the attribute definitions */ select * from <table>;
spool off
set termout on
/

Or, was there something I missed about your question? Cheers,

gary         -=- visit The C Programmers' Reference -=-
          http://users.southeast.net/~garyg/C_ref/C/c.html
               The AVENUE Programmers' Class Requests
             http://users.southeast.net/~garyg/class.htm
Received on Sat Feb 15 1997 - 00:00:00 CST

Original text of this message

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