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