readable out data from table

Hi all,

How can I export data from 1 table to .txt or .xls file? I know exp/imp won't do it.
Thanks,

You can write a SQL query that will dump the data in required format.

Write a small plsql script using the utl_file.
http://technet.oracle.com/docs/produ...ile.htm#998101

Sam

Can some one give me an example, I need results from

select * from emp;

into a .txt file or .csv file

Parameter UTL_FILE_DIR not set up in iniPROD.ora yet. Is there a way to work around?

Ergent, please help.

what is your OS?

Sam

spool c:\documents\emp.txt

select * from emp;

spool off

NT-sp6a