关闭

关闭

关闭

封号提示

内容

首页 Oracle PLSQL程序设计(第5版)(上下册).pdf

Oracle PLSQL程序设计(第5版)(上下册).pdf

Oracle PLSQL程序设计(第5版)(上下册).pdf

上传者: chang 2012-07-09 评分 0 0 0 0 0 0 暂无简介 简介 举报

简介:本文档为《Oracle PLSQL程序设计(第5版)(上下册)pdf》,可适用于IT/计算机领域,主题内容包含OraclePLSQLProgrammingDownloadatWoweBookComDownloadatWoweBookComFIFTHEDITI符等。

OraclePLSQLProgrammingDownloadatWoweBookComDownloadatWoweBookComFIFTHEDITIONOraclePLSQLProgrammingStevenFeuersteinwithBillPribylBeijing•Cambridge•Farnham•Köln•Sebastopol•Taipei•TokyoDownloadatWoweBookComOraclePLSQLProgramming,FifthEditionbyStevenFeuersteinwithBillPribylCopyrightStevenFeuersteinandBillPribylAllrightsreservedPrintedintheUnitedStatesofAmericaPublishedbyO’ReillyMedia,Inc,GravensteinHighwayNorth,Sebastopol,CAO’Reillybooksmaybepurchasedforeducational,business,orsalespromotionaluseOnlineeditionsarealsoavailableformosttitles(http:mysafaribooksonlinecom)Formoreinformation,contactourcorporateinstitutionalsalesdepartment:()orcorporateoreillycomEditors:DeborahRussellandJulieSteeleProductionEditor:LoranahDimantProductionServices:Newgen,IncIndexer:EllenTroutmanZaigCoverDesigner:KarenMontgomeryInteriorDesigner:DavidFutatoIllustrator:RobertRomanoPrintingHistory:September:FirstEditionSeptember:SecondEditionSeptember:ThirdEditionAugust:FourthEditionSeptember:FifthEditionNutshellHandbook,theNutshellHandbooklogo,andtheO’ReillylogoareregisteredtrademarksofO’ReillyMedia,IncOraclePLSQLProgramming,theimageofants,andrelatedtradedressaretrademarksofO’ReillyMedia,IncManyofthedesignationsusedbymanufacturersandsellerstodistinguishtheirproductsareclaimedastrademarksWherethosedesignationsappearinthisbook,andO’ReillyMedia,Incwasawareofatrademarkclaim,thedesignationshavebeenprintedincapsorinitialcapsOracleandallOraclebasedtrademarksandlogosaretrademarksorregisteredtrademarksofOracleCorporation,Inc,intheUnitedStatesandothercountriesO’ReillyMedia,Inc,isindependentofOracleCorporationJavaandallJavabasedtrademarksandlogosaretrademarksorregisteredtrademarksofSunMicrosystems,Inc,intheUnitedStatesandothercountriesO’ReillyMedia,Inc,isindependentofSunMicrosystems,IncMicrosoft,Windows,andallMicrosoftbasedtrademarksandlogosaretrademarksorregisteredtrademarksofMicrosoft,Inc,intheUnitedStatesandothercountriesO’ReillyMedia,IncisindependentofMicrosoft,IncWhileeveryprecautionhasbeentakeninthepreparationofthisbook,thepublisherandauthorsassumenoresponsibilityforerrorsoromissions,orfordamagesresultingfromtheuseoftheinformationcontainedhereinISBN:MDownloadatWoweBookComTomyfather,SheldonFeuerstein,whoseintellectualcuriosity,personalintegrity,anddevotiontofamilyinspiremedailyStevenFeuersteinTomyfatherBillPribylDownloadatWoweBookComDownloadatWoweBookComTableofContentsPrefacexxviiPartIProgramminginPLSQLIntroductiontoPLSQLWhatIsPLSQLTheOriginsofPLSQLTheEarlyYearsofPLSQLImprovedApplicationPortabilityImprovedExecutionAuthorityandTransactionIntegrityHumbleBeginnings,SteadyImprovementSoThisIsPLSQLIntegrationwithSQLControlandConditionalLogicWhenThingsGoWrongAboutPLSQLVersionsOracleDatabasegNewFeaturesResourcesforPLSQLDevelopersTheO’ReillyPLSQLSeriesPLSQLontheInternetSomeWordsofAdviceDon’tBeinSuchaHurry!Don’tBeAfraidtoAskforHelpTakeaCreative,EvenRadicalApproachCreatingandRunningPLSQLCodeNavigatingtheDatabaseCreatingandEditingSourceCodeSQL*PlusStartingUpSQL*PlusRunningaSQLStatementviiDownloadatWoweBookComRunningaPLSQLProgramRunningaScriptWhatIsthe“CurrentDirectory”OtherSQL*PlusTasksErrorHandlinginSQL*PlusWhyYouWillLoveandHateSQL*PlusPerformingEssentialPLSQLTasksCreatingaStoredProgramExecutingaStoredProgramShowingStoredProgramsManagingGrantsandSynonymsforStoredProgramsDroppingaStoredProgramHidingtheSourceCodeofaStoredProgramEditingEnvironmentsforPLSQLCallingPLSQLfromOtherLanguagesC:UsingOracle’sPrecompiler(Pro*C)Java:UsingJDBCPerl:UsingPerlDBIandDBD::OraclePHP:UsingOracleExtensionsPLSQLServerPagesAndWhereElseLanguageFundamentalsPLSQLBlockStructureAnonymousBlocksNamedBlocksNestedBlocksScopeQualifyallReferencestoVariablesandColumnsinSQLStatementsVisibilityThePLSQLCharacterSetIdentifiersReservedWordsWhitespaceandKeywordsLiteralssEmbeddingSingleQuotesInsideaLiteralStringNumericLiteralsBooleanLiteralsTheSemicolonDelimiterCommentsSingleLineCommentSyntaxMultilineCommentSyntaxviii|TableofContentsDownloadatWoweBookComThePRAGMAKeywordLabelsPartIIPLSQLProgramStructureConditionalandSequentialControlIFStatementsTheIFTHENCombinationTheIFTHENELSECombinationTheIFTHENELSIFCombinationAvoidingIFSyntaxGotchasNestedIFStatementsShortCircuitEvaluationCASEStatementsandExpressionsSimpleCASEStatementsSearchedCASEStatementsNestedCASEStatementsCASEExpressionsTheGOTOStatementTheStatementImprovingProgramReadabilityUsingAfteraLabelIterativeProcessingwithLoopsLoopBasicsExamplesofDifferentLoopsStructureofPLSQLLoopsTheSimpleLoopTerminatingaSimpleLoop:EXITandEXITWHENEmulatingaREPEATUNTILLoopTheIntentionallyInfiniteLoopTheWHILELoopTheNumericFORLoopRulesforNumericFORLoopsExamplesofNumericFORLoopsHandlingNontrivialIncrementsTheCursorFORLoopExampleofCursorFORLoopsLoopLabelsTheCONTINUEStatementTipsforIterativeProcessingUseUnderstandableNamesforLoopIndexesTableofContents|ixDownloadatWoweBookComTheProperWaytoSayGoodbyeObtainingInformationAboutFORLoopExecutionSQLStatementasLoopExceptionHandlersExceptionHandlingConceptsandTerminologyDefiningExceptionsDeclaringNamedExceptionsAssociatingExceptionNameswithErrorCodesAboutNamedSystemExceptionsScopeofanExceptionRaisingExceptionsTheRAISEStatementUsingRAISEAPPLICATIONERRORHandlingExceptionsBuiltinErrorFunctionsCombiningMultipleExceptionsinaSingleHandlerUnhandledExceptionsPropagationofUnhandledExceptionsContinuingPastExceptionsWritingWHENOTHERSHandlingCodeBuildinganEffectiveErrorManagementArchitectureDecideonYourErrorManagementStrategyStandardizeHandlingofDifferentTypesofExceptionsOrganizeUseofApplicationSpecificErrorCodesUseStandardizedErrorManagementProgramsWorkwithYourOwnException“Objects”CreateStandardTemplatesforCommonErrorHandlingMakingtheMostofPLSQLErrorManagementPartIIIPLSQLProgramDataWorkingwithProgramDataNamingYourProgramDataOverviewofPLSQLDatatypesCharacterDataNumbersDates,Timestamps,andIntervalsBooleansBinaryDataROWIDsREFCURSORsx|TableofContentsDownloadatWoweBookComInternetDatatypes“Any”DatatypesUserDefinedDatatypesDeclaringProgramDataDeclaringaVariableDeclaringConstantsTheNOTClauseAnchoredDeclarationsAnchoringtoCursorsandTablesBenefitsofAnchoredDeclarationsAnchoringtoNOTDatatypesProgrammerDefinedSubtypesConversionBetweenDatatypesImplicitDataConversionExplicitDatatypeConversionStringsStringDatatypesTheVARCHARDatatypeTheCHARDatatypeStringSubtypesWorkingwithStringsSpecifyingStringConstantsUsingNonprintableCharactersConcatenatingStringsDealingwithCaseTraditionalSearching,Extracting,andReplacingPaddingTrimmingRegularExpressionSearching,Extracting,andReplacingWorkingwithEmptyStringsMixingCHARandVARCHARValuesStringFunctionQuickReferenceNumbersNumericDatatypesTheNUMBERTypeThePLSINTEGERTypeTheBINARYINTEGERTypeTheSIMPLEINTEGERTypeTheBINARYFLOATandBINARYDOUBLETypesTheSIMPLEFLOATandSIMPLEDOUBLETypesNumericSubtypesTableofContents|xiDownloadatWoweBookComNumberConversionsTheTONUMBERFunctionTheTOCHARFunctionTheCASTFunctionImplicitConversionsNumericOperatorsNumericFunctionsRoundingandTruncationFunctionsTrigonometricFunctionsNumericFunctionQuickReferenceDatesandTimestampsDatetimeDatatypesDeclaringDatetimeVariablesChoosingaDatetimeDatatypeGettingtheCurrentDateandTimeIntervalDatatypesDeclaringINTERVALVariablesWhentoUseINTERVALsDatetimeConversionsFromStringstoDatetimesFromDatetimestoStringsWorkingwithTimeZonesRequiringaFormatMasktoMatchExactlyEasingUponExactMatchesInterpretingTwoDigitYearsinaSlidingWindowConvertingTimeZonestoCharacterStringsPaddingOutputwithFillModeDateandTimestampLiteralsIntervalConversionsConvertingfromNumberstoIntervalsConvertingStringstoIntervalsFormattingIntervalsforDisplayIntervalLiteralsCASTandEXTRACTTheCASTFunctionTheEXTRACTFunctionDatetimeArithmeticDateArithmeticwithIntervalsandDatetimesDateArithmeticwithDATEDatatypesComputingtheIntervalBetweenTwoDatetimesMixingDATEsandTIMESTAMPsAddingandSubtractingIntervalsxii|TableofContentsDownloadatWoweBookComMultiplyingandDividingIntervalsUsingUnconstrainedINTERVALTypesDateTimeFunctionQuickReferenceRecordsRecordsinPLSQLBenefitsofUsingRecordsDeclaringRecordsProgrammerDefinedRecordsWorkingwithRecordsComparingRecordsTriggerPseudoRecordsCollectionsCollectionsOverviewCollectionsConceptsandTerminologyTypesofCollectionsCollectionExamplesWhereYouCanUseCollectionsChoosingaCollectionTypeCollectionMethods(Builtins)TheCOUNTMethodTheDELETEMethodTheEXISTSMethodTheEXTENDMethodTheFIRSTandLASTMethodsTheLIMITMethodThePRIORandNEXTMethodsTheTRIMMethodWorkingwithCollectionsDeclaringCollectionTypesDeclaringandInitializingCollectionVariablesPopulatingCollectionswithDataAccessingDataInsideaCollectionUsingStringIndexedCollectionsCollectionsofComplexDatatypesMultilevelCollectionsWorkingwithCollectionsinSQLNestedTableMultisetOperationsTestingEqualityandMembershipofNestedTablesCheckingforMembershipofanElementinaNestedTablePerformingHighLevelSetOperationsHandlingDuplicatesinaNestedTableTableofContents|xiiiDownloadatWoweBookComMaintainingSchemaLevelCollectionsNecessaryPrivilegesCollectionsandtheDataDictionaryMiscellaneousDatatypesTheBOOLEANDatatypeTheRAWDatatypeTheUROWIDandROWIDDatatypesGettingROWIDsUsingROWIDsTheLOBDatatypesWorkingwithLOBsUnderstandingLOBLocatorsEmptyVersusLOBsWritingintoaLOBReadingfromaLOBBFILEsAreDifferentSecureFilesVersusBasicFilesTemporaryLOBsNativeLOBOperationsLOBConversionFunctionsPredefinedObjectTypesTheXMLTypeTypeTheURITypesTheAnyTypesPartIVSQLinPLSQLDMLandTransactionManagementDMLinPLSQLAQuickIntroductiontoDMLCursorAttributesforDMLOperationsRETURNINGInformationfromDMLStatementsDMLandExceptionHandlingDMLandRecordsTransactionManagementTheCOMMITStatementTheROLLBACKStatementTheSAVEPOINTStatementTheSETTRANSACTIONStatementTheLOCKTABLEStatementAutonomousTransactionsxiv|TableofContentsDownloadatWoweBookComDefiningAutonomousTransactionsRulesandRestrictionsonAutonomousTransactionsTransactionVisibilityWhentoUseAutonomousTransactionsBuildinganAutonomousLoggingMechanismDataRetrievalCursorBasicsSomeDataRetrievalTermsTypicalQueryOperationsIntroductiontoCursorAttributesReferencingPLSQLVariablesinaCursorChoosingBetweenExplicitandImplicitCursorsWorkingwithImplicitCursorsImplicitCursorExamplesErrorHandlingwithImplicitCursorsImplicitSQLCursorAttributesWorkingwithExplicitCursorsDeclaringExplicitCursorsOpeningExplicitCursorsFetchingfromExplicitCursorsColumnAliasesinExplicitCursorsClosingExplicitCursorsExplicitCursorAttributesCursorParametersSELECTFORUPDATEReleasingLockswithCOMMITTheWHERECURRENTOFClauseCursorVariablesandREFCURSORsWhyCursorVariablesSimilaritiestoStaticCursorsDeclaringREFCURSORTypesDeclaringCursorVariablesOpeningCursorVariablesFetchingfromCursorVariablesRulesforCursorVariablesPassingCursorVariablesasArgumentsCursorVariableRestrictionsCursorExpressionsUsingCursorExpressionsRestrictionsonCursorExpressionsTableofContents|xvDownloadatWoweBookComDynamicSQLandDynamicPLSQLNDSStatementsTheEXECUTEIMMEDIATEStatementTheOPENFORStatementAbouttheFourDynamicSQLMethodsBindingVariablesArgumentModesDuplicatePlaceholdersPassingValuesWorkingwithObjectsandCollectionsDynamicPLSQLBuildDynamicPLSQLBlocksReplaceRepetitiveCodewithDynamicBlocksRecommendationsforNDSUseInvokerRightsforSharedProgramsAnticipateandHandleDynamicErrorsUseBindingRatherThanConcatenationMinimizetheDangersofCodeInjectionWhentoUseDBMSSQLParseVeryLongStringsObtainInformationAboutQueryColumnsMeetMethodDynamicSQLRequirementsMinimizeParsingofDynamicCursorsOracleDatabasegNewFeaturesDBMSSQLTOREFCURSORFunctionDBMSSQLTOCURSORFunctionEnhancedSecurityforDBMSSQLPartVPLSQLApplicationConstructionProcedures,Functions,andParametersModularCodeProceduresCallingaProcedureTheProcedureHeaderTheProcedureBodyTheENDLabelTheRETURNStatementFunctionsStructureofaFunctionTheRETURNDatatypeTheENDLabelxvi|TableofContentsDownloadatWoweBookComCallingaFunctionFunctionsWithoutParametersTheFunctionHeaderTheFunctionBodyTheRETURNStatementParametersDefiningParametersActualandFormalParametersParameterModesExplicitAssociationofActualandFormalParametersinPLSQLTheNOCOPYParameterModeQualifierDefaultValuesLocalorNestedModulesBenefitsofLocalModularizationScopeofLocalModulesSprucingUpYourCodewithLocalModulesModuleOverloadingBenefitsofOverloadingRestrictionsonOverloadingOverloadingwithNumericTypesForwardDeclarationsAdvancedTopicsCallingYourFunctionFromInsideSQLTableFunctionsDeterministicFunctionsGoForthandModularize!PackagesWhyPackagesDemonstratingthePowerofthePackageSomePackageRelatedConceptsDiagrammingPrivacyRulesforBuildingPackagesThePackageSpecificationThePackageBodyInitializingPackagesRulesforCallingPackagedElementsWorkingwithPackageDataGlobalWithinaSingleOracleSessionGlobalPublicDataPackagedCursorsSerializablePackagesWhentoUsePackagesTableofContents|xviiDownloadatWoweBookComEncapsulateDataAccessAvoidHardcodingLiteralsImproveUsabilityofBuiltinFeaturesGroupTogetherLogicallyRelatedFunctionalityCacheStaticSessionDataPackagesandObjectTypesTriggersDMLTriggersDMLTriggerConceptsCreatingaDMLTriggerDMLTriggerExample:NoCheatingAllowed!MultipleTriggersoftheSameTypeWhoFollowsWhomMutatingTableErrorsCompoundTriggers:PuttingItAllInOnePlaceDDLTriggersCreatingaDDLTriggerAvailableEventsAvailableAttributesWorkingwithEventsandAttributesDroppingtheUndroppableTheINSTEADOFCREATETriggerDatabaseEventTriggersCreatingaDatabaseEventTriggerTheSTARTUPTriggerTheSHUTDOWNTriggerTheLOGONTriggerTheLOGOFFTriggerTheSERVERERRORTriggerINSTEADOFTriggersCreatinganINSTEADOFTriggerTheINSTEADOFINSERTTriggerTheINSTEADOFUPDATETriggerTheINSTEADOFDELETETriggerPopulatingtheTablesINSTEADOFTriggersonNestedTablesAFTERSUSPENDTriggersSettingUpfortheAFTERSUSPENDTriggerLookingattheActualTriggerTheORASPACEERRORINFOFunctionTheDBMSRES

用户评论(3)

0/200
  • 物ad_002 2013-05-24 18:48:42

    英文版,英文水平有限,看起来会有些吃力。

  • 故乡的雪 2013-01-21 22:25:51

    英文版的 OK 非常好

  • 10.44.7.248 2013-01-02 05:19:14

    非常感谢,一直在找这方面的资料,好好学习一下

精彩专题

上传我的资料

每篇奖励 +2积分

资料评价:

/49
仅支持在线阅读

意见
反馈

立即扫码关注

爱问共享资料微信公众号

返回
顶部