Re: sqlldr Question

From: Sunil <sunil_franklin_at_hotmail.com>
Date: Tue, 21 May 2002 22:30:39 +0530
Message-ID: <u7vG8.4$sg6.177@news.oracle.com>

I will give some more info on my problem

The file is of the structure

name_1, my_data_1
name_2, my_data_A
name_3, my_data_xyz
name_4, my_data_pqrst

Now this may change to

name_1, my_data_1
name_2, my_data_B
name_3, my_data_xyz
name_4, my_data_pqrst
name_5, my_data_lmnop

In this case I want the extra row for "name_5" to be inserted and the row for name_2 to be updated from my_data_B to my_data_A.

Thanks In Advance,
Sunil.

"Sunil" <sunil_franklin_at_hotmail.com> wrote in message news:pYuG8.3$sg6.34_at_news.oracle.com...
> 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.
>
>
>
Received on Tue May 21 2002 - 12:00:39 CDT