Hi Oracle DBA users,
I need your help here:
I am trying to write a trigger to reduce 1 day from 4 date fields of a table (order)
table name = order
fields = date_1, date_2, date_11, date_12 and dest_id
for example: the trigger will verify if orders that are dropping is for a specific customer (dest_id).
if yes, the trigger will subtract one day from these date fields (by updating them);
if no, (the dest_id is not for this customer) the trigger will not update anything in the DB
I am a bit confused with the coding. Hope someone could help me to write this.
If you need more details, just let me know.
Thanks in advance!