Skip to Content
0
Jun 18, 2020 at 08:27 AM

Update date fields based on insert/update rows

320 Views

Hi all,

I have the following requirement.

I need to perform full load of a source table into a target table.

If source record primary key already exists into target table, the record must be updated, else the record must be inserted.

Now, my requirement is:

-give the value sysdate() to the fields INSERT_DATE and UPDATE_DATE into target table when the record is inserted

-update (with the value sysdate() ) only the field UPDATE_DATE into target table when the record is updated.

Could anyone help me?

Regards,

Fabio