Re: Creating a delimited text file with SQL*Plus / PL/SQL

Ter Bear <t_porter_at_ix.netcom.com> wrote:
> All I need is all fields, one
>row per line, each field separated by a | (or comma, or whatever).
>
set space 0;
set feedback off;
set pagesize 0;
set heading off;

spool file_name;

select column_1||','||colun_2||','||column_3||   from table_name;

spool off;

try it out.

• sanjay d.s.