资源描述:
《入门基础——oracle快速入门(introduction to foundations -- oracle quick start)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、入门基础——oracle快速入门(Introductiontofoundations--Oraclequickstart)Introductiontofoundations--OraclequickstartI.passwordmodificationPasswordmodificationmethod:1.SQL>,grant,connect,to,USRNAME,identified,by,USRPWD;2.SQL>,alter,user,USRNAME,identified,by,USRPWD
2、;3.SQL>passwordUSRNAME;ChangethepasswordforUSRNMAEOldpassword:********Newpassword:********Retypethenewpassword:********ModifiedtoOracleauthenticationmethod:1.modifytheparameterfileRemote_login_passwordfile=EXCLUSIVEorSHARED2.modifythe/home/network/admi
3、n/SQLNET.ORAfileIncreasesqlnet.authentication_services=(NFS)ORACLE_SIDistheoperatingsystemlevelparameterINSTANCE_NAMEisthedatabaselevelparameterSPFILEistheserverparameterfilePFILEisatextparameterfileCreatepfile='/oracle/test.ora'fromspfile;Showparamete
4、rSPFILE;thenSPFILEisnotusediftheVALUEvalueiszero.Thebootdatabasecanbespecifiedwhethertostartwithpfileorwithspfile:Startuppfile='/oracle/test.ora'ShowparameterinstanceShowparameterDBAltersystemsetjob_queue_processes=50Comment='temporatychangeon'Scope=me
5、mory
6、spfile
7、both;AltersessionsetCONCAT('Good','String')GoodStringSUBSTR('String',1,3)StrLENGTH('String')6INSTR('String','r')3LPAD(SAL,10*******5000)UnionUnionallMinusthefirstquerysubtractssecondqueriesIntersectionofintersectSQL>,select,replace('itpub,o
8、racle','oracle','training'),itpub,from,dual/ITPUB-ItpubtrainingTranslateSQL>,select,translate('This,is,trianing,of,itpub,in,Beijing,second,...,'abcde','12345')itpub2fromdual;ITPUBChinaThis,is,s53on4,tri1ning,of,itpu2,in,B5ijing!FloorSQL>selectfloor(4.5
9、5)fromdual;FLOOR(4.55)AtFourCeilSQL>selectceil(4.55)fromdual;CEIL(4.55)DearsirsreFiveROUND:4drops5intothespecifieddecimalplaceROUND(45.926,2)45.93TRUNC:truncatethevaluetothespecifieddecimalplaceTRUNC(45.926,2)45.92MOD:returnstheremainderafterdividingMO
10、D(1600,300)100SelectTRUNC(sysdate,'D')-3,from,dual;TRUNC(sysdate,'D')interceptedtothefirstdayoftheweek(0:00)TRUNC(sysdate,'M')interceptedtothefirstdayofthemonth(0:00)TRUNC(sysdate,'DD')intercepteduntil0:00todayTRUNC(sysdate,'yyyy')got0: