insert into DEPARTMENT values('B300',
                            '2023-04-01',
                            NULL,
                            '新設部門',
                            (select LAYER from DEPARTMENT where DEPT_CODE = 'A100'),
                            (select UP_DEPT_CODE from DEPARTMENT where DEPT_CODE = 'A100'),
                            '1',
                            (select UPDATE_USER_NAME from DEPARTMENT where DEPT_CODE = 'A100'),
                            '2023-04-01 00:00:00'
);
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');