Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Q:Save a Table on ASCII file
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.htmReceived on Sat Feb 15 1997 - 00:00:00 CST