Write Trigger With this command the address of the employee will be updated to new CITY, STREET and BLDG numbers. CREATE TABLE EMPLOYEE (E# NUMBER(4), ENAME VARCHAR2(10), MANAGER# NUMBER(4), HIREDATE...

Write Trigger With this command the address of the employee will be updated to new CITY, STREET and BLDG numbers.

CREATE TABLE EMPLOYEE
(E#        NUMBER(4),
   ENAME    VARCHAR2(10),
   MANAGER#    NUMBER(4),
   HIREDATE    DATE,
   SALARY    NUMBER(7),
   COMM        NUMBER(7,2),
   DNAME    VARCHAR2(14),
   CITY       VARCHAR(13),
   STREET#   NUMBER(3),
   BLDG#       NUMBER(4),
   LEVEL#   NUMBER(2)
PRIMARY KEY(E#));