INSERT INTO DEPARTMENT 
VALUES('B300','2023-04-01',NULL,'新設部門','2','1000','1','SYSTEM',
        '2023-04-01 00:00:00');

--SELECT * FROM DEPARTMENT;

UPDATE DEPARTMENT SET END_DATE = '2023-03-31',VALID_FLG = '0',
USER_UPDATE_DATETIME = '2023-03-31 23:59:59'
WHERE DEPT_CODE='A100' OR DEPT_CODE='A200';

--SELECT * FROM DEPARTMENT;

UPDATE EMP SET DEPT_CODE='B300',START_DATE='2023-04-01',
       UPDATE_USER_NAME = 'ORG_CHG',USER_UPDATE_DATETIME= '2023-04-01 00:00:00';

SELECT * FROM EMP
  INNER JOIN DEPARTMENT 
    ON EMP.DEPT_CODE=DEPARTMENT.DEPT_CODE;