博文
(2011-05-04 10:42:58)
·DATAtypehastheabilitytostorethemonth,day,year,century,hours,minutes,andseconds.·Torepresentthedatestoredinamorereadableformat,useTO_CHARfunctionFormattingadateSQL>SELECTTO_CHAR(date1,'MM/DD/YYYYHH24:MI:SS')"Date"FROMdate_table;Date---------------------------06/20/200316:55:1406/26/200311:16:36·Whenyoudosubtractionbetweendates,yougetanumberthatrepresentsthenumberofdays.Youshouldthenmu...[阅读全文]
(2011-02-24 09:41:35)
WebDesign(whichIamstudyingnow):http://www.qujon.com/content/?312.html
ASPWebTechnique:http://www.qujon.com/content/?607.html
PHP+MySql:http://www.qujon.com/content/?953.html,http://www.qujon.com/content/?1035.html
CIRClub:http://circlub.com/
TheConquestofParadise:http://www.tudou.com/programs/view/eSl9EDA2mBI/
53rdGrammyAwardsonFeb132011:http://v.youku.com/v_show/id_XMjQzN...[阅读全文]
(2011-01-18 13:17:31)
HowtouseLogMinertoRestoreDataOracle8iprovidesanewtooltofindoutwhatOracleiswritingtotheredologfilescalledLogMiner.Thelogfilesstoreallthedataneededtoperformadatabaserecoveryandrecordallchanges(INSERT,UPDATEandDELETE)madetothedatabase.LogMinerisasetofPL/SQLpackagesanddynamic(V$)views.Thepackagesareinstalledwiththeinstallationofthedatabase.TheviewshoweverwillbecreatedonthemomentyoustartupLogMinerbyusi...[阅读全文]
(2010-11-19 10:00:51)
***TraditionalChineseMedicineAcupuncturePoint:http://www.mifang.org/am/pic/
***Jotti'sMalware:http://virusscan.jotti.org/en
***VoiceTrainingForSinging:http://www.njjz.net/gh/show.aspx?id=157&cid=38
***GoodVideoCllections:http://my-best-video.blogspot.com/
[阅读全文]
***Jotti'sMalware:http://virusscan.jotti.org/en
***VoiceTrainingForSinging:http://www.njjz.net/gh/show.aspx?id=157&cid=38
***GoodVideoCllections:http://my-best-video.blogspot.com/
[阅读全文]
(2010-09-23 08:45:42)
HowtoKillOracleSessionsMakesureyouknowwhatyouaredoingThereareanumberofwaystokillroguesessionsbothwithinOracleandexternally.Thefirststepistoidentifythesessiontobekilledbygv$sessions.Thebasicsyntaxforkillingasessionisshownbelow.SQL>ALTERSYSTEMKILLSESSION'sid,serial#';InaRACenvironment,youoptionallyspecifytheINST_ID,shownwhenqueryingtheGV$SESSIONview.ThisallowsyoutokillasessionondifferentRACnode.SQL>...[阅读全文]
(2010-09-22 12:58:05)
***Sessions***
Connecttodatabasethroughsqlpluscreateasession.Asessioncanbeforcedtobeterminatedwiththealtersystemkillsessionstatement.Note:Thealtersystemkillsessionstatementwillnotmakethesessiongoawayuntilittimesoutorittriestoissueanotherstatement.However,pmonwillrollbacktheworkdonebythesession.TheserverprocesswaitsthenuntiltheclienttriestoexecuteanotherstatementtosenditaORA-03113EOFoncomm...[阅读全文]
(2010-01-28 15:16:37)
UsingFunctionIndexToEnforceConditionalUniqueOnMultipleColumns
CREATEUNIQUEINDEXONSUBSTR(DECODE(STATUS,1,TEAMID||'/'JOB,NULL),1,110);
Fordetails,seebelow:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1249800833250
[阅读全文]
(2009-02-18 14:04:12)
HereisalistforPracleproductbasepricelistfromwww.oracle.com
http://www.oracle.com/corporate/pricing/technology-price-list.pdf
NamedUserPlus:isdefinedasanindividualauthorizedbyyoutousetheprogramswhichareinstalledonasingleserverormultipleservers,regardlessofwhethertheindividualisactivelyusingtheprogramsatanygiventime.Anonhumanoperateddevicewillbecountedasanameduserplusinadditiontoallindividua...[阅读全文]
http://www.oracle.com/corporate/pricing/technology-price-list.pdf
NamedUserPlus:isdefinedasanindividualauthorizedbyyoutousetheprogramswhichareinstalledonasingleserverormultipleservers,regardlessofwhethertheindividualisactivelyusingtheprogramsatanygiventime.Anonhumanoperateddevicewillbecountedasanameduserplusinadditiontoallindividua...[阅读全文]
(2009-02-18 13:45:42)
KeyFeatureSummaryExpressEdition
10gStandardEditionOneStandardEditionEnterpriseEditionMaximum1CPU2Sockets4SocketsNoLimitRAM1GBOSMaxOSMaxOSMaxDatabaseSize4GBNoLimitNoLimitNoLimitWindowsLinuxUnix64BitSupportHighAvailabilityReadMoreTotalRecall
Providessecure,efficient,easy-to-useandapplication-transparentsolutionforlong-termstorageofhistoricaldata.ReadMoreOptionActiveDataGuard
Enhance...[阅读全文]
(2009-02-17 15:23:08)
EM10gGridControlOverviewEnterpriseManager10gGridControlprovidesasingleinterfaceformonitoringandmanagingyourentireOracleeco-system.Thebaselevelfunctionalityincludes:enterprisehealthstatusincludingtargetavailabilityreal-timemonitoringandalertingdatabase/applicationserveradministrationandmaintenancetargetgroupingjobautomationenterprisereporting1.DatabasehomepageTheOracleDatabaseHomepageallowsyoutovie...[阅读全文]
