Oracle PL/SQL：Expert Techniques For Developers and Database Administrators

图书标准信息

• 作者 Lakshman Bulusu 著
• 出版社 Cengage Learning
• 出版时间 2008-05
• 版次 1
• ISBN 9781584505549
• 定价 336.60元
• 装帧 平装
• 开本 其他
• 纸张 其他
• 页数 288页
• 正文语种 英语

【内容简介】

WelcomeaboardthefirstbookfocusingexclusivelyonPL/SQLtechniques,throughOracle11g.Thesetechniquesaretried-tested-true,yetdonotcompromiseperformance.You'llfindcoverageofalltypesofscenarios,startingfromdesigntocodingandtestingtodebuggingandtuning.PL/SQLismorethanjusta3GLsequeltoSQL;insteaditcanbeusedasamethodologyforapplicationdevelopmentusingOracle.Thetechniquescoveredherehaveabroaderscope,inapplicationsrangingfromOLTPtoOLAPandfromdatawarehousingtobusinessintelligence.TheworldofPL/SQLisexcitingandthisbookprovidesarepositoryoftechniquesforPL/SQLdevelopersandDBAsalike.Thisbooktakesyoubeyondtheexistingsolutionsfoundinotherprofessionalandreferencetextsorinonlinedocumentation.StartingfromPL/SQLinternalsthatincludePL/SQLprogramstructure,internalrepresentation,compilation,andexecution,usersaretaughtPL/SQLconceptsandtechniquesthatgowaybeyondSQL,suchasdatastructuremanagement,errormanagement,datamanagement,applicationmanagement,andtransactionmanagement.Itcoversthepractical'how-to'techniquesofapplyingthesePL/SQLconceptsinliveprojectsandelaboratesonvariousPL/SQLframeworks,theintegrationofPL/SQLwithJava,andWeb-enablingPL/SQL.ThelasttwochaptersonPL/SQLtuninganddebuggingandPL/SQLcodingstandardscontaincomprehensivecoverageofperformance-enhancingtechniquesandPL/SQLcodingstandardsthatcan'tbefoundinanywhereelse.Alltechniquesincludeexamplesandhands-oncode,aswellastipsandcodingstandards.ThecompanionCD-ROMincludesallthesourcecodefortheexamplesinthebook.

【作者简介】

LakshmanBulusuisanexperiencedOracleProfessionalwithmorethan15yearsofextensiveexperienceinsoftwaremanagement,design,anddevelopmentusingOracleanditsrelatedtechnologies,includingPL/SQLandJava.He?stheauthorofOracleDeveloperFormsTechniquesandOracleandJavaDevelopment,Oracle9iPL/SQL:ADeveloper?sGuide,andOracleProgrammingFAQ.HeholdsanOracleMasterscredentialandanOCPcertificationfromOracleCorporation,andisadoublehonorsgraduateincomputerscienceandengineeringandmathematics.HehaspresentedatnumerousinternationalandnationalconferencesonOracleanditstoolsandpublishedarticlesinvarioustechnicalmagazinesandjournalsintheUnitedStatesandtheUnitedKingdom.Currently,asaTechnicalManagerforSoftwareDevelopmentatGenexTechnologies,heoverseesthemanagement,design,anddevelopmentofmission-criticalOracleprojectsformajorclientsacrosstheU.S.,Europe,andAsia.

【目录】

PartI:IntroductoryConcepts
Chapter1:IntroductiontoPL/SQL
Chapter2:PL/SQLbyDissection
Chapter3:NewFeaturesinPL/SQL

PartII:TechniquesforPL/SQLProgramming
Chapter4:DataStructureManagementinPL/SQL
Chapter5:ErrorManagementinPL/SQL
Chapter6:DataManagementinPL/SQL
Chapter7:ApplicationManagementinPL/SQL
Chapter8:TransactionManagementinPL/SQL

PartIII:ApplyingPL/SQLintherealworld
Chapter9:ApplicationDevelopmentFrameworksUsingPL/SQL
Chapter10:ApplyingPL/SQLin3GLandWebEnvironment
Chapter11:MiscellaneousTechniques
Chapter12:PL/SQLTuningandDebugging
Chapter13:PL/SQLCodingStandards