readable out data from table

[elintrend]

Hi all,

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

[svk]

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

[sambavan]

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

Sam

[elintrend]

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.

[sambavan]

what is your OS?

Sam

[rygi]

spool c:\documents\emp.txt

select * from emp;

spool off

[elintrend]

NT-sp6a