创建表
create table student(
stuId number(4),
stuName varchar2(20),
classId number(5)
)
create table classResource(
id number(5) primary key,
name varchar(40) not null
)
唯一约束unique
alter table student modify(stuName unique)
外键约束 alter table1 add constraint xxx foreign key(table1ID) references table2(table2ID)
alter table student add constraint fk_classId foreign key(classId) references classResource(id);
主键约束alter table table1 add constraint xxx primary key(table1ID)
alter table student add constraint pk_stuId primary key(stuId);
insert into student(stuId,stuName) values(1003,'赵六');
insert into student values (1004, '王五', 80003);
insert into student values (1002, 'albert', 80009);
insert into student values (1001, 'andrew', 80005);
insert into classResource values(80000,'语文');
insert into classResource values(80001,'数学');
insert into classResource values(80002,'英语');
insert into classResource values(80003,'物理');
insert into classResource values(80004,'化学');
insert into classResource values(80005,'生物');
insert into classResource values(80006,'历史');
insert into classResource values(80007,'地理');
insert into classResource values(80008,'政治');
insert into classResource values(80009,'美术');
内连接 inner join on
select a.*,b.* from student a inner join classResource b on a.classid=b.id
左连接 left join on
select a.*,b.* from student a left join classResource b on a.classid=b.id
右连接 right join on
select a.*,b.* from student a right join classResource b on a.classid=b.id
全连接 full join on
select a.*,b.* from student a full join classResource b on a.classid=b.id