资源描述：
《数据库源代码》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。
1、createuserU_22002identifiedbysayougou;grantconnect,resourcetoU_22002;connectU_22002/sayougou;createtablereader_U_22002(rnochar(10)constraintreader_U22002_rno_pkprimarykey,rnamevarchar(32),sexvarchar(4)constraintreader_U_22002_sex_ckcheck(sexin('男','女','其他','其它')),agenumber(3),telvarchar2(1
2、3),emailvarchar2(32));insertintoreader_U_22002values('9091101120','张三','男',11,'07311560','24601243931');insertintoreader_U_22002values('9091120021','张文博','男',12,'07311561','24601243932');insertintoreader_U_22002values('9091101122','张冠','男',13,'07311562','24601243933');insertintoreader_U_22
3、002values('9091101123','李四','男',14,'07311563','24601243934');insertintoreader_U_22002values('9091101124','王五','男',15,'07311564','24601243935');insertintoreader_U_22002values('9091101125','赵六','男',16,'07311565','24601243936');insertintoreader_U_22002values('9091101126','万七','男',17,'07311566
4、','24601243937');insertintoreader_U_22002values('9091101127','郑八','男',18,'07311567','24601243938');insertintoreader_U_22002values('9091101128','珂九','男',19,'07311568','24601243939');insertintoreader_U_22002values('9091101129','秦十','男',20,'07311569','24601243940');insertintoreader_U_22002val
5、ues('9091101130','李正四','男',20,'07311570','24601243941');createtablebook_U_22002(bnochar(10)Primarykey,btitleVARCHAR2(32),authorVARCHAR2(32),publishervarchar2(32)，pricenumber(7,2)check(price<10000));insertintobook_U_22002values('110','数据库1','鼠','出版社','1000');insertintobook_U_22002values('11
6、1','数据库2','虎','出版社','2000');insertintobook_U_22002values('112','数据库3','牛','出版社','3000');insertintobook_U_22002values('113','数据库4','马','出版社','4000');insertintobook_U_22002values('114','数据库5','兔','出版社','5000');insertintobook_U_22002values('115','数据库6','龙','出版社','6000');insertintobook_U_22002
7、values('116','数据库7','猴','出版社','7000');insertintobook_U_22002values('117','数据库8','鸡','出版社','8000');insertintobook_U_22002values('118','数据库9','狗','出版社','9000');insertintobook_U_22002values('119','数据库0','蛇','出版社','0000');createtablelend_U_22002(rnochar(10)referen
