INSERT INTO DEPARTMENT(DEPT_CODE,START_DATE,END_DATE,DEPT_NAME,LAYER,UP_DEPT_CODE,VALID_FLG,UPDATE_USER_NAME,USER_UPDATE_DATETIME)

VALUES("B300","2023-04-01",NULL,"新設部門","2","1000","1","SYSTEM","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",
               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';