Re: Tool wanted, that converts EXP-files into CSV-format

Hi,
Use SQL*Plus tool to create csv files from tables For example if you have a table emp with 3 columns namely empno,ename,job

SET TERMOUT OFF
SET FEEDBACK OFF
SET HEADING OFF SPOOL EMP.CSV
SELECT EMPNO||','||'"||ENAME||'",'||'"'||JOB||'"' FROM EMP; SPOOL OFF Hope this helps

AMARENDRA Gerd Streubel wrote:

> Hello everybody,
>
> does anybody know a tool, that converts dump files generated by EXP into
> CSV-format?
> Or does a tool exists, that exports ORACLE Tables into CSV-files?
> (CSV: comma separated values)
>
> Any suggestions are highly welcome.
>
> Regards
> Gerd Streubel
> Email: ges_at_gse.de

--
*****************************************************************
AMARENDRA B NETTEM
Oracle Certified DBA (OCP)
Whittman-Hart Inc.,
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.

Residence:
-----------
5039 N E River Road,
Apt. 1A
NORRIDGE, IL 60656


Ph.No. (708) 583 9870 (H)
       (312) 913 6758 (W)

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************
Opinions are mine and do not necessarily reflect those
of Whittman-hart Inc.