Time event Triggers in oraclegreenspun.com : LUSENET : OpenKnowledge : One Thread
1. 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 (firstname.lastname@example.org), January 16, 2003
i am also searching for a sams stuff plz forward me if u get some idea
-- prem kumar (email@example.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 (firstname.lastname@example.org), October 07, 2003.
how to write logical tigger
-- irshad (email@example.com), July 18, 2004.
2.select deptno from emp where sal=(select max(sal) from emp) /
-- subba reddy (firstname.lastname@example.org), August 03, 2004.
I want to same thing ;;;;; also I want help to write programs and run in specefic time plese help me;
-- alhashemi (email@example.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 (firstname.lastname@example.org), October 18, 2004.