Hi all,
How can I export data from 1 table to .txt or .xls file? I know exp/imp won't do it.
Thanks,
Printable View
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