insert into department (
    DEPT_CODE
    ,START_DATE
    ,END_DATE
    ,DEPT_NAME
    ,LAYER
    ,UP_DEPT_CODE
    ,VALID_FLG
    ,UPDATE_USER_NAME
    ,USER_UPDATE_DATETIME
)
select 
  'B300' as DEPT_CODE
  ,'2023-04-01' as START_DATE 
  ,NULL as END_DATE 
  ,'新設部門' as DEPT_NAME
  ,LAYER 
  ,UP_DEPT_CODE
  ,'1' AS VALID_FLG 
  ,UPDATE_USER_NAME
  ,'2023-04-01 00:00:00' AS USER_UPDATE_DATETIME
from department 
where dept_code = 'A100'
;



-- 2
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')
;


-- 3

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