部门(部门号,名称,经理名,地址,电话号)
职工(职工号,姓名,年龄,职务,工资,部门号)
一、在Hr用户模式下,创建职工和部门表,各插入2条测试数据。
select *
from v$nls_parameters t
where t.PARAMETER='NLS_CHARACTERSET';
create table Dept
(
Deptno char(9) ,
Deptname varchar2(8),
Deptmanager varchar2(12),
Deptaddress varchar2(20),
Deptphone char(11),
primary key(Deptno)
);
drop table Dept;
select *
from Dept;
create table Emp
(
Empno char(9) ,
Empname varchar2(8),
Empage char(4),
Empjob varchar2(10),
Empsal smallint,
Empdeptno char(9),
primary key(Empno),
foreign key(Empdeptno) references Dept(Deptno)
);
drop table Emp;
select *
from Emp;
insert into Dept values('201400644','学习部','张三','湖北大学','12345678910');
insert into Dept values('201400645','卫生部','李四','湖北大学','0987654321');
insert into Emp values('201400789','王五',25,'销售人员',1200,'201400644');
insert into Emp values('201400790','李明',26,'监督人员',1200,'201400645');