关闭

关闭

关闭

封号提示

内容

首页 Oracle9i.The.Complete.Reference.pdf

Oracle9i.The.Complete.Reference.pdf

Oracle9i.The.Complete.Reference…

上传者: syyg2008 2010-12-18 评分 0 0 0 0 0 0 暂无简介 简介 举报

简介:本文档为《Oracle9i.The.Complete.Referencepdf》,可适用于IT/计算机领域,主题内容包含ORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFol符等。

ORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:iOraclei:TheCompleteReferenceKevinLoneyGeorgeKochAndtheExpertsatTUSCMcGrawHillOsborneNewYorkChicagoSanFranciscoLisbonLondonMadridMexicoCityMilanNewDelhiSanJuanSeoulSingaporeSydneyTorontoP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:iiMcGrawHillOsborneTenthStreetBerkeley,CaliforniaUSAToarrangebulkpurchasediscountsforsalespromotions,premiums,orfundraisers,pleasecontactMcGrawHillOsborneattheaboveaddressForinformationontranslationsorbookdistributorsoutsidetheUSA,pleaseseetheInternationalContactInformationpageimmediatelyfollowingtheindexofthisbookOraclei:TheCompleteReferenceCopyrightbyTheMcGrawHillCompanies,Inc(Publisher)AllrightsreservedPrintedintheUnitedStatesofAmericaExceptaspermittedundertheCopyrightActof,nopartofthispublicationmaybereproducedordistributedinanyformorbyanymeans,orstoredinadatabaseorretrievalsystem,withoutthepriorwrittenpermissionofPublisherOracleisaregisteredtrademarkandOracleiisatrademarkorregisteredtrademarkofOracleCorporationDOCDOCBookpnandCDpnpartsofISBNPublisherBrandonANordinVicePresidentAssociatePublisherScottRogersAcquisitionsEditorLisaMcClainProjectEditorLeeAnnPickrellAcquisitionsCoordinatorAthenaHonoreTechnicalEditorBobBrylaCopyEditorMargaretBersonProofreaderCherylAbelIndexerJamesMinkinComputerDesignersTabithaMCagan,LucieEricksenIllustratorsMichaelMueller,LyssaWaldCoverSeriesDesignDamoreJohannDesign,IncThisbookwascomposedwithCorelVENTURAPublisherInformationhasbeenobtainedbyPublisherfromsourcesbelievedtobereliableHowever,becauseofthepossibilityofhumanormechanicalerrorbyoursources,Publisher,orothers,Publisherdoesnotguaranteetotheaccuracy,adequacy,orcompletenessofanyinformationincludedinthisworkandisnotresponsibleforanyerrorsoromissionsortheresultsobtainedfromtheuseofsuchinformationOracleCorporationdoesnotmakeanyrepresentationsorwarrantiesastotheaccuracy,adequacyorcompletenessofanyinformationcontainedinthisWork,andisnotresponsibleforanyerrorsoromissionsP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenTomyparents,andtoSue,Emily,Rachel,andJaneKLToElwoodBrant,Jr(Woody),–GKORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:iiiP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:ivAbouttheAuthorsKevinLoneyisaseniormanagementtechnicalconsultantwithTUSC(http:wwwtusccom),anOraclefocusedconsultancyheadquarteredinChicagoHeisanexpertintheadministration,tuning,security,recovery,design,anddevelopmentofOracledatabasesandapplicationsAnOracleDBAanddevelopersince,heistheprimaryauthorofnumerousbooks,includingOracleiDBAHandbook,OracleiInstantScripts,andOracleAdvancedTuningandAdministration,allpublishedbyOraclePressHeisafrequentpresenteratlocalandinternationalOracleusergroupsGeorgeKochisaleadingauthorityonrelationaldatabaseapplicationsApopularspeakerandwidelypublishedauthor,heisalsothecreatorofTHESIS,thesecuritiestrading,accounting,andportfoliomanagementsystemthatwasthefirstmajorcommercialapplicationsproductintheworldtoemployarelationaldatabase(Oracle)andprovideEnglishlanguagequeryingtoitsusersHeisaformerseniorvicepresidentofOracleCorporationP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochChapterBlindFolio:vvContentsAtaGlancePARTICriticalDatabaseConceptsSharingKnowledgeandSuccessTheDangersinaRelationalDatabaseTheBasicPartsofSpeechinSQLTheBasicsofObjectRelationalDatabasesIntroductiontoWebEnabledDatabasesPARTIISQLandSQL*PLUSBasicSQL*PLUSReportsandCommandsGettingTextInformationandChangingItPlayingtheNumbersDates:Then,Now,andtheDifferenceConversionandTransformationFunctionsGroupingThingsTogetherWhenOneQueryDependsuponAnotherSomeComplexPossibilitiesBuildingaReportinSQL*PLUSChangingData:insert,update,merge,anddeleteAdvancedUseofFunctionsandVariablesDECODEandCASE:if,then,andelseinSQLCreating,Dropping,andAlteringTablesandViewsByWhatAuthorityChangingtheOracleSurroundingsP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenviOraclei:TheCompleteReferenceORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:viUsingSQL*LoadertoLoadDataAccessingRemoteDataUsingMaterializedViewsUsingOracleTextforTextSearchesUsingExternalTablesUsingFlashbackQueriesPARTIIIPLSQLAnIntroductiontoPLSQLTriggersProcedures,Functions,andPackagesPARTIVObjectRelationalDatabasesImplementingTypes,ObjectViews,andMethodsCollectors(NestedTablesandVaryingArrays)UsingLargeObjectsAdvancedObjectOrientedConceptsPARTVJavainOracleAnIntroductiontoJavaJDBCandSQLJProgrammingJavaStoredProceduresPARTVIHitchhiker’sGuidesTheHitchhiker’sGuidetotheOracleiDataDictionaryTheHitchhiker’sGuidetotheOracleOptimizerTheHitchhiker’sGuidetoOracleiASTheHitchhiker’sGuidetoDatabaseAdministrationTheHitchhiker’sGuidetoXMLinOraclePARTVIIAlphabeticalReferenceAlphabeticalReferenceP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:viiAcknowledgmentsThisbookisdedicatedtomyfamily,whohaveallowedmethetimetowriteitThankyouforyourpatienceandsupportandloveBeyondthat,thisbookisdedicatedtothememoryoftwopeople:StephenJayGouldandMatthewHorningStephenJayGouldinspiredmetobeatechnicalwriterhissteadygrowthasawriterandhisclarityofthoughtandexpressionmademebelievethiskindofwritingwasapossibilityHepassedawayasthisbookwasbeingfinished,andtheworldispoorerforhispassingMatthewHorningwasanOracleDBAIworkedwithforseveralweeksduringthesummerofontheupperfloorsof#WorldTradeCenterinNewYorkCityHehadthemisfortuneofbeingintheofficeearlyonHiscoworkerswereinspiringtoworkwithduringtherecoveryeffortsthatfollowedInhisobituary,Matt’sfamilyaskedthatdonationsinhismemorybegiventoHeiferInternational(http:wwwheiferorg)Ifanactofcompassioncancomeoutofsuchdestruction,thentheremayalwaysbehopeAsGouldnoted,“Ordinarykindnesstrumpsparoxysmalevilbyatleastamillioneventstoone”Thisbookistheproductofmanyhands,andcountlesshoursfrommanypeopleMythanksgoouttoallthosewhohelped,whetherthroughtheircomments,feedback,edits,orsuggestionsForadditionalinformationaboutthebook,seethepublisher’ssite(http:wwwosbornecom)andmysite(http:wwwkevinloneycom)Additionalarticlesandpresentationscanbefoundonthecompanysiteathttp:wwwtusccomThankstoallofmycolleaguesatTUSC:Tothecontributorsandreviewersthere,includingBradBrown,JayUrban,andMikeHolderTotheexemplarymanagement,includingJakeVanderVort,RichNiemiec,JoeTrezzo,BradBrown,andothersIt’sadelighttoworkwithanexecutiveteamwhounderstandstherequirementsofthiskindofundertakingandwhosharesacommitmenttoprofessionalaltruismThankstotherestofthemanagementteamtherewhoactivelypursuetheprofessionaltraitsTUSCvaluesTomypeersatTUSC,includingMikeAult,BillCallahan,PatrickCallahan,HollyClawson,JudyCorley,MarkGreenhalgh,AndyHamilton,MikeKillough,AllenPeterson,RandySwanson,BobTaylor,BobYingst,andmanyothersfortheirinsightsandcontributionsviiP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenSpecialthankstoBobBryla,whoservedastechnicaleditorforthiseditionHisthoroughness,corrections,andsuggestionsweregreatlyappreciatedImaginebeingatechnicaleditoronapagebookcoveringsucharangeofcontentandyoucanbegintoappreciateBob’staskthendoitwhileworkingonmyschedule!Thankstomycolleaguesandfriends,includingEyalAronoff,JohnBeresniewicz,SteveBobrowski,RachelCarmichael,StevenFeuerstein,MikeMcDonnell,MarleneTheriault,MikeJanesch,CraigWarman,andVinnySmithThisbookhasbenefitedfromtheknowledgetheyhaveshared,andIhavebenefitedfromtheirfriendshipandguidanceThankstothefolksatMcGrawHillOsbornewhoguidedthisproductthroughitsstages:ScottRogers,LeeAnnPickrell,AthenaHonore,LisaMcClain,andJeremyJudson,andtheothersatOsbornewithwhomIneverdirectlyworkedThanksalsototheOraclecomponentofOraclePressThisbookwouldnothavebeenpossiblewithouttheearlierexcellentworkofGeorgeKochandRobertMullerThankstothewritersandfriendsalongtheway:JerryGrossJanRiessRobertMeissnerMarieParettiBrDeclanKane,CFXBrWilliamGriffin,CFXChrisO’NeillCherylBittnerBillFlemingandMikeRestucciaThankstotheFirstStateOracleUserGroupboard(PeteSilva,PhilStewart,EarlShaffer,andLoriKaupas)foritssupport(http:wwwfsougorg)SpecialthankstoSue,Emily,Rachel,Jane,andtherestofthehometeamAsalways,thishasbeenajointeffortKevinLoneyviiiOraclei:TheCompleteReferenceORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:viiiP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenORACLESeriesTIGHTOraclei:TheCompleteReferenceLoney,KochFrontMatterBlindFolioFM:ixPrefaceTheIntriguingHistoryofThisBookIfirstencounteredOraclein,intheprocessofevaluatingdatabasemanagementsystemsforamajorcommercialapplicationthatmycompanywaspreparingtodesignandbuildAtitsconclusion,ourevaluationwascharacterizedbyComputerWorldasthesinglemost“grueling”studyofDBMSsthathadeverbeenconductedThestudywassotoughonthevendorswhoseproductsweexaminedthatwordofitmadethepressasfarawayasNewZealandandpublicationsasfarafieldastheChristianScienceMonitorWebeganthestudywithcandidatecompanies,thennarrowedthefieldtosixteenfinalists,includingmostofthemajordatabasevendorsofthetime,andalltypesofdatabases:network,hierarchical,relational,andothersAftertherigorousfinalroundofquestions,twoofthemajorvendorsparticipatingaskedthattheresultsofthestudyoftheirproductsneverbepublishedAsalesmanfromathirdvendorquithisjobattheendofoneofthesessionsWeknewhowtoasktoughquestionsOracle,knownthenasRelationalSoftware,Inc,hadfewerthanemployeesatthetime,andonlyafewmajoraccountsNevertheless,whenthestudywascompleted,weannouncedOracleasthewinnerWedeclaredthatOraclewastechnicallythebestproductonthemarket,andthatthemanagementteamatRSIlookedcapableenoughtocarrythecompanyforwardsuccessfullyOurradicalproclamationwasmadeatatimewhenfewpeopleevenknewwhatthetermrelationalmeant,andthosewhodidhadveryfewpositivethingstosayaboutitManyISexecutivesloudlycriticizedourconclusionsandpredictedthatOracleandtherelationaldatabasewouldgonowhereOracletodayisthelargestdatabasecompany,andthesecondlargestsoftwarecompanyintheworldTherelationaldatabaseisnowtheworldstandardKochSystemsCorporation,thecompanyIownedandranatthetime,becameOracle’sfirstValuedAddedResellerWedevelopedtheworld’sfirstmajorcommercialrelationalapplication,asecuritiestradingandaccountingsystemcalledTHESISThisproductwasusedbymajorbanksandcorporationstomanagetheirinvestmentportfoliosEvenIBMboughtTHESIS,anditallowedOracletobeinstalledatIBMheadquartersinspiteofvigorousinternaloppositionAfterall,IBMwastheleadingdatabasecompanyatthetime,withIMSandDBastheirflagshipproductsOraclewascontinuingtorefineitsyoungproduct,tounderstandthekindsoffeaturesandfunctionalitythatwouldmakeitproductiveandusefulinthebusinessworld,andourdevelopmenteffortsatKochSystemscontributedtothatrefinementSomeofOracle’sfeatureswerethedirectixP:CompOracleCDVenturabookvpFriday,July,::PMColorprofile:GenericCMYKprinterprofileCompositeDefaultscreenresultsofrequeststhatwemadeofOracle’sdevelopers,andouroutspokenadvocacyofanenduserbiasinapplicationdesignandnamingconventionshasinfluencedagenerationofprogrammerswholearnedOracleinourshoporreadarticleswhichwepublishedAllofthisintimateinvolvementwiththedevelopmentanduseofOracleledustoanearlyandunmatchedexpertisewiththeproductanditscapabilitiesSinceIhavealwayslovedsharingdiscoveriesandknowledgetohelpshortenthelearningtimenecessarywithnewtechnologiesandideas,andsaveothersthecostofmakingthesamemistakesIdidIdecidedtoturnwhatwe’dlearnedintoabookOracle:TheCompleteReferencewasconceivedintopulltogetherallofthefundamentalcommandsandtechniquesusedacrosstheOracleproductline,aswellasgivesolidguidanceinhowtodevelopapplicationsusingOracleandSQLPartIofthebookwasaimedbothatdevelopersandendusers,sothattheycouldshareacommonlanguageandunderstandingduringtheapplicationdevelopmentprocess:developersandendusersworkingsidebysideawildconceptwhenthebookwasfirstconceivedLindaAllen,arespectedliteraryagentinSanFrancisco,introducedmetoLizFisher,thentheeditoratMcGrawHillOsborneLizlikedtheideaverymuchContractsweredrawn,andthefirsteditionwasscheduledtobereleasedinButanowdepartedseniorexecutiveatMcGrawHillheardoftheprojectandinstantlycanceleditsdevelopment,pronouncingthatOracleisaflashinthepanItisgoingnowhereAyearlater,whenOracleCorporationhadagaindoubledinsizeandtheseniorexecutivewasgone,theeffortwasrestarted,andthefirsteditionfinallyar

用户评论(0)

0/200

精彩专题

上传我的资料

每篇奖励 +2积分

资料评价:

/49
仅支持在线阅读

意见
反馈

立即扫码关注

爱问共享资料微信公众号

返回
顶部