Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

Oracle training Weblogic Book
Easy Oracle Jumpstart
Oracle training & performance tuning books
Burleson Consulting Remote DB Administration
Closed TopicStart new topic
> DB trigger to subtract 1 day
post Mar 14 2012, 09:35 AM
Post #1


Group: Members
Posts: 1
Joined: 14-March 12
Member No.: 46,927

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!
Go to the top of the page
+Quote Post
post Mar 14 2012, 04:54 PM
Post #2

Advanced Member

Group: Members
Posts: 12,662
Joined: 26-January 04
Member No.: 13

>> reduce 1 day from 4 date fields

See here:


>> Hope someone could help me to write this.

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

For Oracle support, go here:


Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
+Quote Post

Closed TopicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:


Lo-Fi Version Time is now: 27th November 2015 - 01:18 AM