SQL help (Oracle)

[TheCrow]

Hi there,

Im working on playing with a database iv made and needing some help.

Iv made code to update SALARY on the staffs join day (dd-mm) which works fine.

UPDATE STAFF
SET SALARY =
   CASE
       WHEN GRADE = '1' THEN SALARY+700
       WHEN GRADE = '2' THEN SALARY+600
       WHEN GRADE = '3' THEN SALARY*1.05
       WHEN GRADE = '4' THEN SALARY*1.04
       ELSE SALARY
   END
WHERE TO_CHAR(JOINDATE, 'DD-MM') = TO_CHAR(SYSDATE, 'DD-MM')

How can i get this to automaticly run this once a day (be it script or trigger etc)

can you get a trigger to work on a WHEN e.g. WHEN systime=0700 sort of idea?

Any help would be great!

Thanks

 

[davetherave2]

could you not run it as a stored procedure
something like this:

CREATE PROCEDURE [PROCEDURE NAME] as


UPDATE STAFF
SET SALARY =
CASE
WHEN GRADE = '1' THEN SALARY+700
WHEN GRADE = '2' THEN SALARY+600
WHEN GRADE = '3' THEN SALARY*1.05
WHEN GRADE = '4' THEN SALARY*1.04
ELSE SALARY
END
WHERE TO_CHAR(JOINDATE, 'DD-MM') = TO_CHAR(SYSDATE, 'DD-MM')

then run this at some sort of schedule. I'm still fairly new to SQL so hope this helps.