Re: Loading words and SQL*Loader

Hi,
Why not use a simple pl/sql script to read in, parse, and insert the values instead of trying to shoehorn it into sql*Loader? Jim

[Quoted] On Jan 25, 11:04 pm, "SQLJ" <sqlju..._at_gmail.com> wrote:
> Hi,
>
> I have a text file which is like
>
> Line1 Number1 Number2 Number3
> Line2 Number4
> Line3 Number5, Number6
>
> There could be any number of lines in the file and each line can have
> variable number of numbers. Numbers are single space separated. The
> maximum possible number of numbers in a single line is probably less
> then 100 but this is not known for sure
>
> Is there a way to use Sql*Loader to load each number as a separate
> value into a table havinhg structure like CREATE TABLE mytab (id int,
> some_number number)?
>
> The method I am using right now is loading the file lines into a
> staging table and then looping through all records and parsing them.
> With large data files this methods appears to be very slow and the
> parsing is CPU intensive. Are there any alternatives?
>
> Thanks,
> Jil
Received on Fri Jan 26 2007 - 18:16:45 CET