score1.txt

oracle操作基础基础基础基础基础基础基础基础基础基础基础基础

create table score1(
  sno varchar2(5),
  cno varchar2(4),
  score number(5,2),
  constraint score_fk_sno foreign key(sno) references student(sno) on delete cascade,
  constraint score_fk_cno foreign key(cno) references course(con) on delete cascade,
  constraint score_pk_sno_cno primary key(sno,cno)
)