Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
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
snakesjc
post Mar 14 2012, 09:35 AM
Post #1


Newbie
*

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
burleson
post Mar 14 2012, 04:54 PM
Post #2


Advanced Member
***

Group: Members
Posts: 11,706
Joined: 26-January 04
Member No.: 13



>> 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


--------------------
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: 22nd November 2014 - 06:36 PM