资源描述：
《Oracle数据库上机》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、1表空间createtablespacegcqdatafile'd:gcq1.dbf'size100m,'d:gcq2.dbf'size100m;createtablespacegcq1datafile'd:gcql1.dbf'size100m,'d:gcql2.dbf'size100m;createtemporarytablespacegcqtemptempfile'd:tempgcq1.dbf'size100m,'d:tempgcq2.dbf'size100m;createusergcqidentifiedby"123"de
2、faulttablespacegcqtemporarytablespacegcqtemp;grantconnect,resourcetogcq;createtablegcqtest(vidint,vnamevarchar(10));insertintogcqtest(vid,vname)values(1,'king');2表管理createtablegcq1(vidint,vnamevarchar(10));select*fromgcq1;createtablegcq2(vidintnotnull,vnamevarchar(10));ins
3、ertintogcq2(vid,vname)values(1,'king');insertintogcq2(vname)values('king');--插入失败select*fromgcq2;createtablegcq3(vidintnotnull,vnamevarchar(10)default'无');insertintogcq3(vid)values(1);insertintogcq3(vid,vname)values(1,'king');select*fromgcq3;/*primarykey主键*/createtablegcq4
4、(vidintprimarykey,vnamevarchar(10));insertintogcq4(vid,vname)values(1,'king');insertintogcq4(vid,vname)values(1,'king');select*fromgcq4;createtablegcq5(vidint,vnamevarchar(10),constraintpk_gcq5primarykey(vid));/*foreignkey外键*/createtableclass(classidintprimarykey,classname
5、varchar(10));createtablestudent(stdidintprimarykey,classidintreferencesclass(classid),stdnamevarchar(10));insertintoclass(classid,classname)values(1,'class1');insertintostudent(stdid,classid,stdname)values(1,1,'king');insertintostudent(stdid,classid,stdname)values(2,2,'kin
6、g1');createtablestudent1(stdidintprimarykey,classidint,stdnamevarchar(10),constraintfk_class_studentforeignkey(classid)referencesclass(classid));/*unique唯一约束*/createtablegcq6(vidintprimarykey,vnamevarchar(10)unique);insertintogcq6(vid,vname)values(1,'king');3视图序列案例createse
7、quencegcqseq1;createsequencegcqseq2startwith1minvalue1maxvalue10nocache;createsequencegcqseq3startwith1minvalue1maxvalue10cyclenocache;selectgcqseq1.nextvalfromdual;selectgcqseq1.currvalfromdual;selectgcqseq2.nextvalfromdual;selectgcqseq2.currvalfromdual;createtablegcqtest
8、(vid1int,vid2int,vid3int);insertintogcqtest(vid1,vid2,vid3)values(gcqseq1.nextval,gcqseq1
