oracle课后习题答案.docVIP

练习6 2.实训题 (2) Create table exer_class( CNO number(2) primary key, CNAME varchar2(20), NUM number(3) ); Create table exer_student( SNO number(4) primary key, SNAME varchar2(10) unique, SAGE number, SEX char(2), CNO number(2) ); (3) Alter table exer_student add constraint ck_sage check (sage0 and sage=100); (4) Alter table exer_student add constraint ck_stu check (sex=M or sex=F) modify sex default M; (5) Create unique index ind_cname on exer_class(cname); (6) Create view stu_class_view (e_sno,e_sname,e_cno,e_cname) AS select sno,sname,cno,cname From exer_student; (7) Create