INSERT INTO DEPARTMENT  
 SELECT
 'B300',
 '2023-04-01',
 NULL,
 '新設部門',
 DP1.LAYER,
 DP1.UP_DEPT_CODE,
 '1',
 DP1.UPDATE_USER_NAME,
 '2023-04-01 00:00:00'
 FROM DEPARTMENT AS DP1
 WHERE DP1.DEPT_CODE ='100';

UPDATE DEPARTMENT 
 SET
 END_DATE = '2023-03-31',
 VALID_FLG = '0',
 UPDATE_USER_NAME = 'ORG_CHG',
 USER_UPDATE_DATETIME = '2023-03-31 23:59:59'
 WHERE DEPT_CODE IN ('A100','A200');
 
UPDATE DEPARTMENT 
 SET
 DEPT_CODE ='B300',
 START_DATE = '2023-04-01',
 UPDATE_USER_NAME = 'ORG_CHG',
 USER_UPDATE_DATETIME = '2023-04-01 00:00:00'
 WHERE DEPT_CODE IN ('A100','A200')AND
 VALID_FLG = '1';
  
SELECT * 
FROM DEPARTMENT;