Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exporting to a csv
You should spool to a file.
example
set heading off verify off feedback off
spool c:\....
select name,sal
from emp;
spool off
Rangan
>From: Michael Johnson <mjohnson138_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Exporting to a csv
>Date: Thu, 04 May 2000 19:57:58 -0800
>
>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.
>
>__________________________________________________
>Do You Yahoo!?
>Send instant messages & get email alerts with Yahoo! Messenger.
>http://im.yahoo.com/
>--
>Author: Michael Johnson
> INET: mjohnson138_at_yahoo.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).