create table teacher(
t_id number primary key, --主键
t_name varchar2(50) not null, --非空
t_profession varchar2(50)
);
create table student2(
stu_id number(10) primary key,
stu_name varchar2(50) unique not null,
stu_age number check(stu_age>0 and stu_age<100),–检查约束年龄范围
stu_gender varchar2(3) default ‘男’ check(stu_gender='男’or stu_gender=‘女’),
tea_id number not null references teacher(t_id),–外键约束 关联teacher中t_id
stu_create_date date default sysdate --数据库系统时间
);
create table subject(
sub_id number primary key,
sub_name varchar2(50) not null,
stu_id number not null,
foreign key(stu_id) references student2(stu_id)
);
create sequence seq_teacher start with 1;–创建序列 起始值1
create sequence seq_student2 start with 1;
create sequence seq_subject start with 1;
insert into teacher (t_id,t_name,t_profession)values(seq_teacher.nextval,‘小红’,‘java’);
insert into teacher (t_id,t_name,t_profession)values(seq_teacher.nextval,‘小黄’,‘c’);
insert into teacher (t_id,t_name,t_profession)values(seq_teacher.nextval,‘小白’,‘c++’);
insert into student2 (stu_id,stu_name,stu_age,stu_gender,tea_id)values(seq_student2.nextval,‘小绿’,20,‘女’,2);
insert into student2 (stu_id,stu_name,stu_age,stu_gender,tea_id)values(seq_student2.nextval,‘小蓝’,21,‘女’,3);
insert into student2 (stu_id,stu_name,stu_age,stu_gender,tea_id)values(seq_student2.nextval,‘小黑’,19,‘男’,4);
insert into subject values(seq_subject.nextval,‘java’,2);
insert into subject values(seq_subject.nextval,‘c’,3);
insert into subject values(seq_subject.nextval,‘c++’,4);
select * from teacher;
select * from student2;
select * from subject;