Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP (How to export a table to a delimetered text file)
Hi,
try this:
set pages 0
set echo off
set feedback off
set colsep '|'
spool <outputfile_name>
select * from <table_name>;
spool off
The key is the colsep character. Set it to anything you like.
regards
Jerry Gitomer