Re: SQL*Loader and Stream Record Format

On Mon, 26 Dec 2005 15:49:26 -0500, "oran johnson"
<mobileoran@xxxxxxxxxxxxx> wrote:

>Grow up Rob. Get married. Get some kids and lecture them.
>
>Regards.
>Oran
>
>On Mon, 26 Dec 2005 15:32:06 -0500, Rob Zijlstra <rj.zijlstra@xxxxxxxxxx>
>wrote:
>
>> On Mon, 26 Dec 2005 14:41:58 -0500, "oran johnson"
>> <mobileoran@xxxxxxxxxxxxx> wrote:
>>
>>> Can I access an internet file (http://www.sometime.com/file.txt) via
>>> slq*loader?
>>>
>>> Thanks
>>> Oran
>>>
>>>
>>> On Sat, 24 Dec 2005 12:26:08 -0500, Frank van Bortel
>>> <frank.van.bortel@xxxxxxxxx> 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
>>
>>
>> Do NOT toppost.
>>
>> BEFORE asking, start with something like
>> http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_overview.html.
>>
>> THEN Google.
>>
>> THEN try your solution YOURSELF.
>>
>> After that -when not working- state ora version etc etc, everything
>> YOU YOURSELF tried and then I know that you did something YOURSELF
>> before you started to ask.
>>
>> Have a nice day.
>>
>> Might be a bit harsh, but I'm gettinmg s.a.t. from thew level of
>> questions lately,
>>
>> Best Regards
>>
>> Rob Zijlstra

Hi Oran,

Still topposting?

No ora version?

What did YOU do besides asking / reacting?

FYI: I'm grown up, am married have children etc. Also have a lot of
expierience with people who are not capable / too lazy to find
something out for themselves.
( Took some time with my chioldren yes, but now I';m very happy to say
thay do not ask me or bother anyone else about thing they can find out
for themselves...)


Best Regards

Rob Zijlstra
.

Relevant Pages

  • Re: SQL*Loader and Stream Record Format
    ... Rob, What did YOU do besides reacting? ... Regards. ... Oracle Database 10g Express Edition Beta 2 Release for Microsoft ... Rob Zijlstra ...
    (comp.databases.oracle.tools)
  • Re: Lost my Help Display
    ... Rob ... > MVP FAQ site: http://mvps.org/ ... >> Both the Task Bar and Manager indicate it's running but it doesn't ... >> Regards; ...
    (microsoft.public.office.misc)
  • Re: Wd 03-Date formats from Excel changed
    ... Rob ... > topic of the "Mail merge in Word 2002" section of fellow MVP Cindy ... >> Source file is an Excel WkBk. ... >> Regards; ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Change Autosave defaults in XL2k
    ... If I forget to change it (I usually set it to 30 min with no prompting) it seems like it ... Rob ... >> Is it possible to change the default settings for AutoSave-specifically ... >> Regards; ...
    (microsoft.public.excel.setup)
  • Re: Sorting after ShowDataForm
    ... Regards, Rob ... "Tom Ogilvy" wrote in message ...
    (microsoft.public.excel.programming)
Loading