hi carp,
CREATE OR REPLACE TRIGGER salary_update_trig
AFTER UPDATE
ON salary
BEGIN
IF TO_NUMBER (TO_CHAR (SYSDATE,'HH24')) > 20
OR TO_NUMBER (TO_CHAR (SYSDATE,'HH24')) < 10
OR TO_CHAR (SYSDATE, 'DAY') IN ('SATURDAY', 'SUNDAY')
THEN
IF UPDATING THEN
RAISE_APPLICATION_ERROR (-20100...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.