Re: SQL*Loader and Stream Record Format

From: oran johnson <mobileoran_at_optonline.net>
Date: Mon, 26 Dec 2005 14:41:58 -0500
Message-ID: <op.s2eoz8oxoireee_at_mobileoran>


Can I access an internet file (http://www.sometime.com/file.txt) via slq*loader?

Thanks
Oran

[Quoted] On Sat, 24 Dec 2005 12:26:08 -0500, Frank van Bortel <frank.van.bortel_at_gmail.com> wrote:

> oran johnson wrote:
>> I have recently downloaded, installed and created a database using
>> Oracle Database 10g Express Edition Beta 2 Release for Microsoft
>> Windows. My table was created and loaded using the load text data
>> option on the Database Home Page. I would like to automate the update
>> process using the SQL*Loader. I hava a text file that contains a 129
>> comma delimited fields per line. I am only interested in fields 1-17.
>> How do I advance the SQL*Loader to the next line after the 17th field?
>>
>> Thanks.
>> Oran
>>
>
> Define the rest as a filler; look up the filler keyword
> in the Utilities Manual

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/
Received on Mon Dec 26 2005 - 20:41:58 CET

Original text of this message