if you are using oracle 9i
you could use an external table
Sunil wrote:
> "Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message
> news:3CEA7FFF.86D071AA_at_exesolutions.com...
>
>>Sunil wrote:
>>
>>
>>>I need to load some data into a table from a file.
>>>Later The file may undergo some changes and these changes will have to
>>>
> be
>
>>>reflected in the table. There is a pk column in the table (name) .
>>>How can I go about this.
>>>
>>>Thanks,
>>>Sunil.
>>>
>>How is this a SQL loader question?
>>
>>In fact ... I don't see a single question mark in your entire post.
>>
> My english Grammer ( or is it punctations ) are not so good, Sorry
> !.
>
>
>
>>I guess, to be helpful, I'll refer you back to the 'Subject' of your
>>
> posting:
>
>>Use SQL Loader.
>>
> I had gone through doc. I see the append and truncate options but am
> confused as I will not be able to use both.
>
>
>
>>If you are trying to find out how to use SQL Loader go to
>>http://technet.oracle.com or http://tahiti.oracle.com.
>>
>>Daniel Morgan
>>
>>
>
>
Received on Tue May 21 2002 - 12:53:06 CDT
