-
How to write data into a flat file
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
-
I think Patrol DB Unload would fit the bill here.
MH
I remember when this place was cool.
-
set head off
set feedback off
spool
should work
Amar
"There is a difference between knowing the path and walking the path."
-
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
Giani
-
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.
-
You can use TEXT_IO package from oracle applications like developer/forms.
Remember the Golden Rule - He who has the gold makes the rules!
===================
Kris109
Ph.D., OCP 8i, 9i, 10g, 11g DBA
-
or dbms_output.put_line('Within PL/SQL');
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|