oracle练习题习题答案张表题.pdfVIP

Oracle 练习题+习题答案(张表+题) create table student( sno varchar2(10) primary key, sname varchar2(20), sage number(2), ssex varchar2(5) ); create table teacher( tno varchar2(10) primary key, tname varchar2(20) ); create table course( cno varchar2(10), cname varchar2(20), tno varchar2(20), constraint pk_course primary key (cno,tno) ); create table sc( sno varchar2(10), cno varchar2(10), score number(4,2), constraint pk_sc primary key (sno,cno) ); /*******初始化学生表的数据******/ insert into student values (#39;s001#39;,#39;张三#39;,23,#39;男 #39;); insert into student values (#39;s002#39;,#39;李四#39;,23,#39;男 #39;); create table student( insert into student values (#39;s003#39;,#39;吴鹏#39;,25,#39;男 #39;); sno varchar2(10) primary key, insert into student values (#39;s004#39;,#39;琴沁#39;,20,#39;女 #39;); sname varchar2(20), insert into student values (#39;s005#39;,#39;王丽#39;,20,#39;女 #39;); sage number(2), insert into student values (#39;s006#39;,#39;李波#39;,21,#39;男 #39;); ssex varchar2(5) insert into student values (#39;s007#39;,#39;刘玉#39;,21,#39;男 #39;); ); insert into student values (#39;s008#39;,#39;萧蓉#39;,21,#39;女 #39;); insert into student values (#39;s009#39;,#39;陈萧晓#39;,23,#39; 女#39;); insert into student values (#39;s010#39;,#39;陈美#39;,22,#39;女 #39;); commit; /******************初始化教师表***********************/ insert into teacher values (#39;t001#39;, #39;刘阳#39;); create table teacher( insert into teacher values (#39;t002#39;, #39;谌燕#39;); tno varchar2(10) primary key, insert into teacher values (#39;t003#39;, #39;胡明星#39;); tname varchar2(20) commit; ); /***************初始化课程表****************************/ insert into course values (#39;c001#39;,#39;J2SE#39;,#39;t002#39;); insert in