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.
May 18, 2009 11:50 AM
February 29, 2012 11:12 PM