Time event Triggers in oraclegreenspun.com : LUSENET : OpenKnowledge : One Thread |
Dear Sir1. I want to write triggers in oracle those will fire automatically on specified time. I heard that those are called as j(g)obs. Plz help me to solve this problem 2. I want to write a query "to get maximum salary paying department"
1 mr.y 1000 deptno(1)
-- Lokesha.K.R (kr_lokesh1980@yahoo.com), January 16, 2003
i am also searching for a sams stuff plz forward me if u get some ideaadvance thanx
-- prem kumar (prem_somanin@yahoo.com), February 24, 2003.
For max(Sal) by each department you can write a corelated sub query as follows.Select a.DepartmentName, a.Sal From department a where max(a.Sal) in (Select Max(b.Sal) from Department b where a.departmentname = b.Departmentname)
-- Renga rajan (s.rengarajen@india.birlasoft.com), October 07, 2003.
how to write logical tigger
-- irshad (sahil87us@yahoo.com), July 18, 2004.
2.select deptno from emp where sal=(select max(sal) from emp) /
-- subba reddy (mails_ksr@yahoo.co.in), August 03, 2004.
I want to same thing ;;;;; also I want help to write programs and run in specefic time plese help me;
-- alhashemi (alhashemi@rediffmail.com), October 04, 2004.
i am also checking for the same one if anyone of u get the answer please forward me
-- Y.Ajay Babu (dirn_123@yahoo.co.in), October 18, 2004.