insert into DEPARTMENT
select DEPT_CODE = 'B300'
     , START_DATE = '2023-04-01'
     , END_DATE = NULL
     , DEPT_NAME = '新設部門'
     , LAYER = A.LAYER
     , UP_DEPT_CODE = A.UP_DEPT_CODE
     , VALID_FLG = '1'
     , UPDATE_USER_NAME = A.UPDATE_USER_NAME
     , USER_UPDATE_DATETIME = '2023-04-01 00:00:00'
from DEPARTMENT A
where 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 VALID_FLG='1' and DEPT_CODE in ('A100','A200');