How to write data into a flat file

[bang_dba]

hi,
is there any tool/program which can be used to write the oracle data into a flat file.
The requirement is just to write the data, but not the structure.

Regards

[Mr.Hanky]

I think Patrol DB Unload would fit the bill here.

MH

[adewri]

set head off
set feedback off
spool

should work

[Giani]

Also if you want to write in html format :

spool your_file.html
set MARKUP HTML ON
..do smthing
set MARKUP HTML OFF
spool off

[slimdave]

If you want to do it purely from the server side, ie. without going through a client tool, then consider using the supplied package "UTL_FILE". Otherwise, SQL*Plus is a good option, using the config statements that adewri gave. You might need to consider setting ..

heading off
linesize 1000 (or a big number)
trimspool on
echo off
feedback off
pagesize 0

.. to name a few.

[kris109]

You can use TEXT_IO package from oracle applications like developer/forms.

[sysdba]

or dbms_output.put_line('Within PL/SQL');