12 lines
723 B
SQL
12 lines
723 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'),
|
|
('A0000002', 'SUZUKI ICHIRO', '20', '02', '002', 350000, 1800, 1, '1'),
|
|
('A0000003', 'YAMADA HANAKO', '10', '01', '001', 280000, 1200, 3, '1'),
|
|
('A0000004', 'SATOU JIRO', '30', '03', '003', 320000, 1600, 0, '1'),
|
|
('A0000006', 'KATO TAKASHI', '20', '02', '002', 500000, 9999999, 4, '1');
|
|
|
|
INSERT INTO OVT_MONTHLY (EMP_ID, YEAR_MONTH, OVT_TYPE, OVT_HOURS, OVT_COUNT) VALUES
|
|
('A0000001', '202310', '1', 10, 5),
|
|
('A0000003', '202310', '1', 5, 2),
|
|
('A0000004', '202310', '1', 8, 4),
|
|
('A0000006', '202310', '1', 50, 10); |