Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Text-file
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