I have 2 tables:
login name status
login name status table_id1
As you can see, Table 2 contains the primary of 1.
by default, the status of table 1 is
when reading a txt file, the status column may have
with success or it can be empty, if that's the case, it stays like
If there is a difference from one of the two previous conditions, the state in both tables is changed to denied.
I make this trigger, which is in Table 2, how can I do it so that the changes also affect Table 1 in case of status change?
DECLARED To start SELECT CASE WHEN: NEW.STATUS = & # 39; SUCEFULLY & # 39; OR: NEW.RESULT = & # 39; THEN & # 39; SUCEFULLY & # 39; OTHERWISE "REFUSAL" END IN: NEW.RESULT FROM DUAL; EXCEPTION WHEN OTHERS THEN - Remember to log the error, then restart it RAISING END TG;