Re: FILE I/O
From: Joseph Ramaswami <jramas_at_acm.org>
Date: Wed, 18 Jul 2001 11:32:57 -0400
Message-ID: <9j4a1v$ef2$1_at_bob.news.rcn.net>
Date: Wed, 18 Jul 2001 11:32:57 -0400
Message-ID: <9j4a1v$ef2$1_at_bob.news.rcn.net>
Actually, I think you should look into SQL Loader. It is the Oracle tool for doing exactly what you want.
Joseph R.
"Geoffrey Dufour" <g.dufour_at_swing.be> wrote in message
news:3b544252$0$4570$ba620e4c_at_news.skynet.be...
> Hello,
>
> I need to insert about 160.000 rows from a flat file (with separators and
> CRs).
>
> How can I handle the reading of the source file in PL/SQL ?
>
> I have been told to use UTL_FILE functions but cannot make it work.
>
> I'm running Oracle 8.0.5.
>
> Regards.
>
>
Received on Wed Jul 18 2001 - 17:32:57 CEST