INSERT INTO DEPARTMENT 
(DEPT_CODE, START_DATE,END_DATE,DEPT_NAME,LAYER,UP_DEPT_CODE,VALID_FLG,
 UPDATE_USER_NAME,USER_UPDATE_DATETIME)
 VALUES ('1100','2024-04-01',NULL,'営業1課',2, '1000','1',
          'TANAKA','2024-04-01 00:00:00');
          
INSERT INTO DEPARTMENT 
(DEPT_CODE, START_DATE,END_DATE,DEPT_NAME,LAYER,UP_DEPT_CODE,VALID_FLG,
 UPDATE_USER_NAME,USER_UPDATE_DATETIME)
 VALUES ('2200','2024-04-10',NULL,'製造2課',2, '2000','1',
          'YAMADA','2024-04-10 00:00:00');
          
SELECT *
  FROM DEPARTMENT
 WHERE DEPT_CODE IN ('1100','2200')