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='A100';


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