we are developing customer care software working on Escalation Module.Here my system should genrate an email to executive or techical head if complain doesn't get resolved within 3-hrs.i am using oracle 9i and forms 6i as frontend.i hv two points to be disscussed.
1). if complain occur at 10.00 am,so it should resolved by 1.00 pm.
how do i calculate time difference between time limit and complain log in time.(pls write query) i am working on following query ,its giving me INVALID NO ERROR.
* select to_char(sysdate,'hh24:mi:ss')-to_char(to_date(21-may-09),'hh24:mi:ss') from tablename;
2)shall i go for trigger for sending an email??? if yes which kind of trigger??? on which event???how??
pls guide me.
i am new in oracle.
thnx in advance.
eagerly waiting for reply
May 22, 2009 11:43 AM
May 23, 2009 6:15 AM