| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Exporting to a csv
Hello all,
Hope everyone is recovered from 'I Love You'.
I am trying to dump a table quickly into a comma-separated file. I was wondering whether there is a utility in Oracle that can do this. There are several in SQL Server which have this capability. I could use a select statement I know, but it wouldn't trim spaces (yes I realize I could take out the spaces with SQL as well). Is there an easier way? I tried EXP but I guess it produces a file that is usable only by IMP. <sigh>
Thanks,
Michael.
 |
 |