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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Text-file

Re: Text-file

From: Ubiquitous <weberm_at_polaris.net>
Date: Sun, 02 Feb 2003 16:41:39 -0600
Message-ID: <ZeqcnR2KzMw-A6CjXTWcpw@comcast.com>


In article <as55kv$78a$1_at_reader1.imaginet.fr>, s.lehaire_at_meilleuregestion.com wrote:

>I know that is possible to write into a file the resultset of a
>query with the spool option, but is it possible to read a text file
>to put the data into a table ?

There's two ways to do this:
SQL*LOADER
   or
A script which reads the file one line at a time (performing edits, if desired) and performing INSERT statements.

-- 
======================================================================
ISLAM: Winning the hearts and minds of the world, one bomb at a time.
Received on Sun Feb 02 2003 - 16:41:39 CST

Original text of this message

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