Hello all,

I would like to export some fields from a table in DB in a txt (log) file, is this possible, I know that sqlldr is used to load data into tables but here i require to output the fields of some table into a txt file or a log file. the table contains some fields which are required in the log file.

please let me know as how to go about this.

Thanks and regards

you could spool the output of your query into file.

ex:

spool /tmp/out
set pagesize 0;
set linesize 0;
set echo off;
set header off;
select * from emp;
spool off

Thanks,

It works as required :-)