INSERT INTO DEPARTMENT VALUES('B300', '2023-04-01', NULL, '新設部門', 0, '1', '1', NULL, '2023-04-01 00:00:00');
UPDATE DEPARTMENT SET LAYER = (SELECT LAYER FROM DEPARTMENT WHERE DEPT_CODE = 'A100');
UPDATE DEPARTMENT SET UP_DEPT_CODE = (SELECT UP_DEPT_CODE  FROM DEPARTMENT WHERE DEPT_CODE = 'A100');
UPDATE DEPARTMENT SET UPDATE_USER_NAME = (SELECT UPDATE_USER_NAME FROM DEPARTMENT WHERE DEPT_CODE = 'A100');

UPDATE DEPARTMENT SET END_DATE = '2023-03-31' WHERE DEPT_CODE IN ('A100', 'A200');
UPDATE DEPARTMENT SET VALID_FLG = '0' WHERE DEPT_CODE IN ('A100', 'A200');
UPDATE DEPARTMENT SET UPDATE_USER_NAME = 'ORG_CHG' WHERE DEPT_CODE IN ('A100', 'A200');
UPDATE DEPARTMENT SET USER_UPDATE_DATETIME = '2023-03-31 23:59:59' WHERE DEPT_CODE IN ('A100', 'A200');


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' WHERE VALID_FLG = '1' AND DEPT_CODE IN ('A100', 'A200');
SELECT
    *
FROM
    DEPARTMENT