建表语句
--员工基本工资表 scott.tb_staff_salary
CREATE TABLE scott.tb_staff_salary(
sal_month char(6) , --基本工资月份,如201604 表示2016年4月
staff_serial number(8), --工号
sal number(18,2), --基本工资
sal_subsidy number(18,2), --津贴
sal_dt char(8) --发放日期,如20160505 表示2016年5月5日
);
alter table scott.TB_STAFF_SALARY
add constraint PK_STAFF_SALARY primary key (SAL_MONTH, STAFF_SERIAL);
insert into scott.tb_staff_salary(sal_month,staff_serial,sal,sal_subsidy,sal_dt) values('201706',1,7000,800,'20170710');
insert into scott.tb_staff_salary(sal_month,staff_serial,sal,sal_subsidy,sal_dt) values('201706',2,6000,800,'20170710');
insert into scott.tb_staff_salary(sal_month,staff_serial,sal,sal_subsidy,sal_dt) values('201706',3,4500,800,'20170710');
insert into scott.tb_staff_salary(sal_month,staff_serial,sal,sal_subsidy,sal_dt) values('201706',4,4600,800,'20170710');
insert into scott.tb_staff_salary(sal_month,staff_serial,sal,sal_subsidy,sal_dt) values('201706',5,4000,500,'20170710');
insert into scott.tb_staff_salary(sal_month,staff_serial,sal,sal_subsidy,sal_dt) values('201706',6,3600,500,'20170710');
--员工信息表 scott.tb_staff_info
CREATE TABLE scott.tb_staff_info(
staff_serial number(8) , --工号
dept char(2) , --部门
staff_name varchar2(10) , --姓名
sex