oracle实验--存储过程.doc

实验实验目的创建图书管理库的图书、读者和借阅三个基本表的表结构：图书表BOOK (BOOK_ID NUMBER(10),SORT VARCHAR2(10),BOOK_NAME VARCHAR2(50),WRITER VARCHAR2(10),OUTPUT VARCHAR2(50),PRICE NUMBER(3)); 读者表READER (READER_ID NUMBER(3),COMPANY VARCHAR2(10),NAME VARCHAR2(10),SEX VARCHAR2(2),GRADE VARCHAR2(10),ADDR VARCHAR2(50));借阅表BORROW (READER_ID NUMBER(3),BOOK_ID NUMBER(10),BORROW_DATE DATE); 插入数据:BOOK表:insert into book values(445501,TP3/12,数据库导论,王强,科学出版社,17.90);insert into book values(445502,TP3/12,数据库导论,王强,科学出版社,17.90);insert into book values(445503,TP3/12,数据库导论,王强,科学出版社,17.90);insert into book values(332211,TP5/10,计算机基础,李伟,高等教育出版社,18.00);insert into book values(112266,TP3/12,FoxBASE,张三,电子工业出版社,23.60);insert into book values(665544,TS7/21,高等数学,刘明,高等教育出版社,20.00);insert into book values(114455,TR9/12,线性代数,孙业,北京大学出版社,20.80);insert into book values(113388,TR7/90,大学英语,胡玲,清华大学出版社,12.50);insert into book values(446601,TP4/13,数据库基础,马凌云,人民邮电出版社,22.50);insert into book values(446602,TP4/13,数据库基础,马凌云,人民邮电出版社,22.50);insert into book values(446603,TP4/13,数据库基础,马凌云,人民邮电出版社,22.50);insert into book values(449901,TP4/14,FoxPro大全,周虹,科学出版社,32.70);insert into book values(449902,TP4/14,FoxPro大全,周虹,科学出版社,32.70);insert into book values(118801,TP4/15,计算机网络,黄力钧,高等教育出版社,21.80);insert into book values(118802,TP4/15,计算机网络,黄力钧,高等教育出版社,21.80); READER表:insert into reader values(111,信息系,王维利,女,教授,1号楼424);insert into reader values(112,财会系,李 立,男,副教授,2号楼316);insert into reader values(113,经济系,张 三,男,讲师,3号楼105);insert into reader values(114,信息系,周华发,男,讲师,1号楼316);insert into reader values(115,信息系,赵正义,男,工程师,1号楼224);insert into reader values(116,信息系,李 明,男,副教授,1号楼318);insert into reader values(117,计算机系,李小峰,男,助教,1号楼214);insert into reader values(118,计算机系,许鹏飞,男,助工,1号楼216);insert into reader values(119,计算机系,刘大龙,男,教授,1号楼318);insert into reader values(120,国际贸易,李 雪,男,副教授,4号楼506);insert into reader values(121,国际贸易,李 爽,女,讲师,4号楼510);insert into reader values(122,国际贸易,王 纯,女,讲师,4号楼512);insert into reader values(123,