Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: csv files

Re: csv files

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Fri, 12 Sep 2003 20:50:35 +1000
Message-ID: <3f61a56c$0$15136$afc38c87@news.optusnet.com.au> 





choqueuv_at_utt.fr wrote:



> Hello,

> 

> I need help!!

> 

>  I do not know how to write transfert csv files on an oracle database

> 

> 

> choqueuv




spool hjr.txt


select empno ||','||ename||','||job||','||mgr from emp;
spool off




Now cat (or 'type') hjr.txt, and start playing.



Regards


HJR

Received on Fri Sep 12 2003 - 05:50:35 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US