Dear Sir

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 (kr_lokesh1980@yahoo.com), January 16, 2003

Answers

i am also searching for a sams stuff plz forward me if u get some idea

advance 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.