Re: SQL*Loader and Stream Record Format

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 24 Dec 2005 18:26:08 +0100
Message-ID: <dojvn9$3cv$1_at_news5.zwoll1.ov.home.nl>


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

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Sat Dec 24 2005 - 18:26:08 CET

Original text of this message