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