Skip to Content
0
Former Member
Dec 05, 2008 at 11:09 AM

Deleting existing record from the oracle if same record number is passed

20 Views

Hi all ,

My requirement is as follows.

There is one condition in XI which restricts certain work groups,These work groups will be changing contantly.

Now my requirement is that ,if a record number say 100 exists in my oracle database,when the same record number is passed again,it should delete the old record which is already in the database and insert this new record.In other words all the records which are sent must be inserted with out duplication.

How to achieve this functionality through XI.

let me know.

Thanks,

Srinivasa