Home > IT Answers > Oracle > Calculate time difference with Oracle 9i
Firasha
25 pts.
0
Q:
Calculate time difference with Oracle 9i
Oracle 9i, Oracle Forms 6i, Oracle development, Oracle triggers
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.
ASKED: May 18 2009  11:50 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Carlosdl
29340 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
To calculate the difference you just need to perform a subtraction, for example:

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
Last Answered: May 18 2009  8:20 PM GMT by Carlosdl   29340 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0