How to write data into a flat file
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.
I think Patrol DB Unload would fit the bill here.
I remember when this place was cool.
set head off
set feedback off
"There is a difference between knowing the path and walking the path."
Also if you want to write in html format :
set MARKUP HTML ON
set MARKUP HTML OFF
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 ..
linesize 1000 (or a big number)
.. to name a few.
You can use TEXT_IO package from oracle applications like developer/forms.
Remember the Golden Rule - He who has the gold makes the rules!
Ph.D., OCP 8i, 9i, 10g, 11g DBA
or dbms_output.put_line('Within PL/SQL');
Click Here to Expand Forum to Full Width