李强.txt

来自「关于oracle和sql的书籍和ppt教程,非常好,本人珍藏品」· 文本 代码 · 共 46 行

create table coure
( 
  coureid    int,
  name       varchar(20) not null,
  credit     number(3)   not null,
  constraint pk2_coureid primary key (coureid) 
)




create table stu7
( 
stuid   int             not null,
name    varchar(20),
sex     char(2),
age     number(2),
coureid int,
grade   number(4,2),
constraint pk1_stuid   primary key (stuid),
constraint fk1_coureid foreign key (coureid) references coure(coureid),
constraint chk0_sex    check (sex in ('男', '女')),
constraint chk1_age    check (age between 18 and 60 ), 
constraint chk2_grade  check (grade > 0)
)


insert into coure values ('20','xy',112);
insert into coure values ('21','zz',168);
.
.


insert into stu7 values ('1','li','男',23,20,88.05);
insert into stu7 values ('2','hh','女',24,21,99.05);
.
.
.



update stu7 set grade=grade+10 where grade<60;

select stuid,name,grade from stu7 where grade<60;