讲义分析java课件

1：Oracle的默认的端15212：Oracle连接的方式Csqlplususer/password@ip:port/xe[assysdba]3：Oracle的物理文件*.ctl*.dbf-*.log4：Oracle的内存结构SGA-系统全局5：SQL

sum/avg/...Groupbyprimarykey -2-31:unique唯一的（（-没有含义但是Oracle用这个值来管理这一行数据）1：通过unique3：唯一可以使用在有意义的列上，如号，如一个网的的用户的名称4nullcreatetableidvarchar(32)primarynameinsertintobooks ','Java基础select*fromselect*fromuser_indexes;-createtableidvarchar(32)primarykey,isbnvarchar(11)unique,namevarchar(50)insertintobooks ','Javaselect*fromselect*fromuser_indexes;altertablealtertablebooksaddconstraintzy_uq1---altertablebooksaddconstraintzy_uq1select*fromCheck;用于约束数据的范围的。如，写入数据表的：0~100createtablet5(nameageintcheck(agebetween0andinsertintot5values('Jack',---要求在创建表以后再修改t5name4且必须以Jaltertableaddconstraintck2check(length(name)>=4andnamelike'J%');insertintot5values('JABCDE',34);createtablet5(namevarchar(30),ageintcheck(agebetween0andinsertintot5values('Jack',---要求在创建表以后再修改t5name4且必须以Jaltertableaddconstraintck2check(length(name)>=4andnamelike'J%');insertintot5values('JABCDE',34);select*fromuser_constraints;altertablet5外键是使用在外键上（，子表上）用于主表上的的主键的值的createtableidvarchar(32)primarykey,namevarchar(30),agecreatetableidvarchar(32)primarykey,namevarchar(30),priceidvarchar(32),--准备将这个列做为外键pesons表中的id的值，所以它的类型必须要与表中的id的类型完全一样表表示类的关系的是UML-统模语、insertintosvalues('P001','Jerry',34);insertintosvalues('P002','Jack',24);insertinto svalues('P003','Alex',14);insertintocarsvalues('C001','Buick',18.3,'P001');insertintocarsvalues('C002','Audi',40,'P001');insertintocarsvalues('C003','BWM',24,'P001');insertintocarsvalues('C004','QQ',2.3,'P002');insertintocarsvalues('C005','Mini',35,null);,fromsp,cars--SQL97selectfromsp,carscwherep.id=c.--建议使用SQL99---innserjoin;内连接,fromspinnerjoincarsconp.id=c.--leftouterjoinselectfromspleftouterjoincarsconp.id=c.--rightouterjoinselectfromsprightouterjoincarsconp.id=c.--fullouterjoinselectfromspfullouterjoincarsconp.id=c.select*fromswhereidin(selectidfromcarswhereselect*fromcarswhereidisselect*fromswhereidselectidfromcarsgroupbyidhavingcount(select*fromswhere(selectcount(*)fromcarswhereid=select*fromswhereidselectidfromcarsgroupbyidhavingcount(id)=(selectmax(count(id))fromcarsgroupbycreatetableidvarchar(32)primarynamecreatetableidvarchar(32)primarykey,namevarchar(30)createtablesc(sc_sidvarchar(32),sc_cidconstraintsc_pkprimaryconstraintsc_fk1foreignkey(sc_sid)referencesstudents(id),constraintsc_fk2foreignkey(sc_cid)referencescourse(id)insertintostudentsvalues('S001','');insertintostudentsvalues('S002','');insertintostudentsvalues('S003','insertintocourseinsertintocoursevalues('C002','Oracle');insertintocoursevalues('C003','PHP');insertintocourseinsertintocoursevalues('C005','HTML');insertintocoursevalues('C006','C#');insertintoscvalues('S001','C001');insertintoscvalues('S001','C002');insertintoscvalues('S001','C003');insertintoscvalues('S001','C004');insertintosc1:查询选择了某selectfromstudentssinnerjoinsconinnerjoin con2Java（作业selectidfromcoursewhereselectsc_sidfromsc1whereSC_CID=(selectidfromcoursewhereNAME='Java');selectnamefromstudentswhereIDin(selectsc_sidfromsc1whereSC_CID=(selectidfromcoursewhereselect*fromstudentsswhere(selectcount(*)fromscwhereselectcount(sc_sid),SC_SIDfromsc1groupbySC_SID;selectmax(count(sc_sid))fromsc1groupbySC_SID;selectsc_sidfromsc1groupbysc_sid =(selectmax(count(sc_sid))fromsc1groupbySC_SID );selectnamefromstuden