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: Billy Verreynne <vslabs_at_onwe.co.za>
Date: 12 Sep 2003 05:18:18 -0700
Message-ID: <1a75df45.0309120418.2e488a9c@posting.google.com>


choqueuv_at_utt.fr (choqueuv_at_utt.fr) wrote :

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

Oracle utility called SQL*Loader.

Or integrated database/SQL*Loader feature called EXTERNAL TABLE option (i.e. creating a table in the database on top of a CSV file). Pretty nifty stuff.

All explained with demo samples in the Oracle9i Database Utilities manual.

Manual available at your friendly on-line RTFM site http://tahiti.oracle.com
(or you can use this URL for direct access to said manual: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96652/toc.htm)

--
Billy
Received on Fri Sep 12 2003 - 07:18:18 CDT

Original text of this message

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