Q:
Calculate time difference with Oracle 9i
1)i wanna calculate difference between current time and time which is stored in table.
how will i calculate the difference between 2 time??
2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i go for any trigger?if yes which trigger ? on which event??? or can i use timer in forms? i am using oracle 9i and forms 6i.pls guide me. i new in oracle.
thnx in advance.
how will i calculate the difference between 2 time??
2) after calculating this difference ,if this difference is greater than 3 hrs my system should genrate an email to technical head. how do i do this?shall i go for any trigger?if yes which trigger ? on which event??? or can i use timer in forms? i am using oracle 9i and forms 6i.pls guide me. i new in oracle.
thnx in advance.
ASKED:
May 18 2009 11:50 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
sysdate - some_date_column
The result will be given in days, so you have to convert it as needed.
To send the e-mail, you could use the UTL_SMTP database package, or write some forms code to use outlook to send it.
Oracle utl_smtp utility to sending e-mail
Forms - Emailing via Outlook
