Re: Loading words and SQL*Loader

On 26 jan, 08:04, "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

Is line1, line2, etc a value, or just to show us it's another line? Assuming it's just an indicator, not a value: use space as new value indicator, with newline as optional Received on Fri Jan 26 2007 - 15:57:26 CET