oracle – Update to two trigger tables

I have 2 tables:

table 1

login
name
status

table 2

login
name
status
table_id1

As you can see, Table 2 contains the primary of 1.

by default, the status of table 1 is with success
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;