updating tables using SQL Loader or pl/sql (tough one)

From: nick <nmudie_at_upctechnology.com>
Date: Sun, 25 Aug 2002 14:27:20 GMT
Message-ID: <cP5a9.359709$Ma.30828169@amsnews02.chello.com>

Hi Guys,

I am reteiving data from my LDAP directory and I am uploading the output into orace tables using SQLloader.

LDAP uses CREATETIMESTAMP to highlight that it's a new record and uses MODIFYTIMESTAMP to highlight that's it's a modified record.

I do a search for CREATIMESTAMP and save it to csv file which I then upload using SQL LOADER.

I do a search for MODIFYTIMESTAMP to find the modified records but how can I use this data to upload the data already in the table .

Obviously the data in the LDAP directroy will change constently and I want to keep the Oracle tables in sync with this....but I don't know how to do updates with this data.

ANY IDEAS ARE MORE THAN APPRECIATED. many thanks in advance,
a very confused man in Holland.

;O)))))
Nicky Mudie

Chello Broadband
Amsterdam. Received on Sun Aug 25 2002 - 09:27:20 CDT