关闭

关闭

封号提示

内容

首页 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

职业精品

精彩专题

上传我的资料

热门资料

资料评价:

/ 1300
所需积分:1 立即下载

意见
反馈

返回
顶部

Q