5 lines
329 B
SQL
5 lines
329 B
SQL
INSERT INTO EMP_MASTER (EMP_ID, EMP_NAME, DEPT_CODE, REGION_CODE, CATEGORY_CODE, BASE_SALARY, HOURLY_RATE, DEPENDENT_COUNT, STATUS) VALUES
|
|
('A0000001', 'TANAKA TARO', '10', '01', '001', 300000, 1500, 2, '1');
|
|
|
|
INSERT INTO OVT_MONTHLY (EMP_ID, YEAR_MONTH, OVT_TYPE, OVT_HOURS, OVT_COUNT) VALUES
|
|
('A0000001', '202310', '1', 10, 5); |