DB trigger to subtract 1 day Options

[snakesjc]

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!

[burleson]

>> reduce 1 day from 4 date fields

See here:

http://www.dba-oracle.com/t_date_arithmetic.htm

*******************************************
>> Hope someone could help me to write this.

No, we cannot provide support services, only answer questions.

For Oracle support, go here:

http://support.oracle.com