insert into department 
values
('B300', '2023-04-01', Null, '新設部門', 0, '0000', '1', Null, '2023-04-01 00:00:00')
;

update department
set
layer = (select layer from department where dept_code='A100')
,up_dept_code = (select up_dept_code from department where dept_code='A100')
,update_user_name = (select update_user_name from department where dept_code='A100')
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')
;


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 order by emp_code;