一頭筆錄oracle11g教程

Java1234免費(fèi)資源匯總：/zy.htmlJava1234VIP資源匯總：/vipzy.html第三節(jié)：PLSQLDeveloperPlsqldeveloper10Plsqldeveloper10下載：/a/javaziliao/kfgj/2015/0815/4776.html下載地址：/s/1o6sx7n0plsqldeveloperNLS_LANG：SIMPLIFIEDCHINESE_CHINA.ZHS16GBKOracleOracle 第一節(jié)：Oracle''自動(dòng)擴(kuò)展大小：createtablespacets2datafileC:\tablespace\ts2.dbf'size50Mautoextendonnext設(shè)置最大空間：createtablespacets3datafileC:\tablespace\ts3.dbfsize50Mautoextendonnext10Mmaxsize表空間改名：altertablespacets1renameto刪除表空間：droptablespacets2includingcontentsand第二節(jié)：Oracleselectsysdatefrom createcreatesequencestartwithnextvalMinvalueMinvaluemaxvalue11027Incrementby屬性序列增長(zhǎng)步長(zhǎng)默認(rèn)值1Cycle（了解即可，不使用）；Cache20 簡(jiǎn)寫insertintodept更新指定數(shù)據(jù)：更新指定數(shù)據(jù)：updatedeptsetdname='司法部wheredeptno=50;updatedeptsetdname='司法部',loc='china'wheredeptno=50;刪除指定數(shù)據(jù)：刪除指定數(shù)據(jù)：deletefromdeptwhere刪除指定條件的數(shù)據(jù)：deletefromdeptwhere查詢所有：查詢所有：select*from指定字段查詢：selectename,salfromwhere條件：select*fromempwheresal>=800;select*fromempwheresal>=1500andjob='SALESMAN';Distinct去重復(fù)記錄；Groupby分組查詢：selectjob,count(ename)asnumfromEMPtgroupbyHaving過濾分組：selectjob,count(ename)asnumfromEMPtgroupbyjobhavingcount(ename)>=2;Orderby排序：select*fromemporderbysaldesc;子查詢：查詢出基本工資大于平均工資的員工：select*fromempwheresal>(selectavg(sal)fromselect*fromunionallselect*fromselect*fromselect*fromselect*fromempt,deptdwhere類似：select*fromempeinnerjoindeptdone.deptno=d.deptno;in