insert into DEPARTMENT
    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' ;
    
--select * from DEPARTMENT where DEPT_CODE = 'B300' ;

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' )  ;
    
--select * from DEPARTMENT 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 where DEPT_CODE = 'B300' ;