SQL> create   table   BK_DEPT
  2  (
  3      DEPTID           NUMBER   not   null,
  4      DEPTNAME       VARCHAR2(50),
  5      DEPTNUMBER   NUMBER,
  6      MEMO1             VARCHAR2(100),
  7      MEMO2             VARCHAR2(1000),
  8      MEMO3             NUMBER
  9  );

Table created

SQL> create   table   BK_ADMINUSER
  2  (
  3      USERID                   NUMBER   not   null,
  4      USERNAME               VARCHAR2(50),
  5      USERPASSWORD       VARCHAR2(20),
  6      USERPHONE             VARCHAR2(20),
  7      USERVIEWNAME       VARCHAR2(20),
  8      USERSDEPTNUMBER         NUMBER,
  9      USERSDEPTNAME     VARCHAR2(50),
 10      USERCREATETIME   VARCHAR2(50),
 11      USERLOGINTIME     VARCHAR2(50),
 12      USEREXITTIME       VARCHAR2(50),
 13      USERTYPENUM         VARCHAR2(500),
 14      USERIP                   VARCHAR2(50)
 15  );

Table created

SQL> INSERT INTO BK_DEPT SELECT 1,'DEPT',8888,'A','B',88 FROM DUAL;

1 row inserted

SQL> INSERT INTO BK_ADMINUSER(USERID,USERSDEPTNUMBER,USERSDEPTNAME) SELECT 1,8888,'HAHA' FROM DUAL;

1 row inserted

SQL> SELECT USERID,USERSDEPTNUMBER,USERSDEPTNAME FROM BK_ADMINUSER;

    USERID USERSDEPTNUMBER USERSDEPTNAME
---------- --------------- --------------------------------------------------
         1            8888 HAHA

SQL> CREATE OR REPLACE TRIGGER TREATE_DATA
  2    AFTER UPDATE ON BK_DEPT FOR EACH ROW
  3  BEGIN
  4    UPDATE BK_ADMINUSER SET BK_ADMINUSER.USERSDEPTNAME = :NEW.DEPTNAME
  5    WHERE BK_ADMINUSER.USERSDEPTNUMBER = :NEW.DEPTNUMBER;
  6  END;
  7  /

Trigger created

SQL> UPDATE BK_DEPT SET DEPTNAME = 'TEST';

1 row updated

SQL> SELECT USERID,USERSDEPTNUMBER,USERSDEPTNAME FROM BK_ADMINUSER;

    USERID USERSDEPTNUMBER USERSDEPTNAME
---------- --------------- --------------------------------------------------
         1            8888 TEST

SQL>