创建表emp，dept，sal；

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
创建表
create table emp
(
empno number(4) not null primary key,
ename varchar2(10) not null,
job varchar2(9) not null,
leader number(4),
hiredate date not null,
sal number(7,2) not null,
bonus number(7,2),
deptno number(2) not null
);

drop table emp;
drop table dept;
drop table sal;

create table dept
(
deptno number(2) not null primary key,
dname varchar2(14) not null,
loc Varchar2(20) not null
);

create table sal
(
levelno number(2) not null primary key,
salmin number(6) not null,
salmax number(6) not null
);

插入
insert into emp
values('7369','smith','clerk',7902,to_date('19801217','YYYYMMDD'),800,null,20);
insert into emp
values('7499','allen','salesman',7698,to_date('19810220','YYYYMMDD'),1600,300,30);
insert into emp
values('7521','ward','salesman',7698,to_date('19810222','YYYYMMDD'),1250,500,30);
insert into emp
values('7566','jones','manager',7839,to_date('19810402','YYYYMMDD'),2975,null,20);
insert into emp
values('7654','martin','salesman',7698,to_date('19810928','YYYYMMDD'),1250,1400,30);
insert into emp
values('7698','blake','manager',7839,to_date('19810501','YYYYMMDD'),2850,null,30);
insert into emp
values('7782','clerk','manager',7839,to_date('19810609','YYYYMMDD'),2450,null,10);
insert into emp
values('7839','king','president',null,to_date('19811117','YYYYMMDD'),5000,null,10);
insert into emp
values('7844','turner','salesman',7698,to_date('19810908','YYYYMMDD'),1500,0,30);
insert into emp
values('7900','james','clerk',7698,to_date('19811203','YYYYMMDD'),950,null,30);
insert into emp
values('7902','ford','analyst',7566,to_date('19811203','YYYYMMDD'),3000,null,20);
insert into emp
values('7934','smith','clerk',7782,to_date('19810123','YYYYMMDD'),1300,null,10);


insert into dept
values(10,'accounting','new york');
insert into dept
values(20,'research','dallas');
insert into dept
values(30,'sales','chicago');
insert into dept
values(40,'operations','boston');

insert into sal
values(1,700,1200);
insert into sal
values(2,1201,1400);
insert into sal
values(3,1401,2000);
insert into sal
values(4,2001,3000);
insert into sal
values(5,3001,9999);

查询
select *
from emp;

select *
from dept;

select *
from sal;