Calculate time difference with Oracle 9i

25 pts.
Tags:
Oracle 9i
Oracle development
Oracle Forms 6i
Oracle triggers
  1. I want to 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 generate 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'm using Oracle 9i and forms 6i. Please guide me. I'm new in Oracle.
Thanks in advance.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following