Expert PL SQL Practices.pdf

《Expert PL SQL Practices.pdf》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、BOOKSFORPROFESSIONALSBYPROFESSIONALS®RosenblumRELATEDExpertPL/SQLPracticesInthisbook,thebestandbrightestinthefieldoffertheircollectedwisdomonPL/SQLprogramming.Eachchapterdeeplyexaminesaspecificproblem,technol-ogy,orfeaturesetthatyou’llfaceasaPL/SQLprogrammer.Together

2、,theyshowyouhowyoucanunleashtruepowerbyproperlycombiningsyntaxandmechan-icswithfeaturesandtechniques.Armedwiththisknowledge,you’llbeabletodomorewithlesseffort,writecodethatscalesandperformswell,andeliminateandavoiddefects.InsideExpertPL/SQLPractices,you’lldiscoverhow

3、to:•KnowwhenitisbesttousePL/SQL,andwhentoavoidit•MovedataefficientlyusingbulkSQLoperations•Writecodethatscalesthroughpipelining,parallelism,andprofiling•ChoosetherightPL/SQLcursortypeforanygivenapplication•Reducecodingerrorsthroughsounddevelopmentpracticessuchasunit-

4、testing•CreateandexecuteSQLandPL/SQLdynamicallyatruntimeTheauthorteamofExpertPL/SQLPracticesarepassionateaboutPL/SQLandthepoweritplacesatyourdisposal.Eachhaschosenhisorhertopicoutofthestrongbeliefthatitcanmakeapositivedifferenceinthequalityandscalabilityofthecodeyouw

5、rite.TheydetailallthatPL/SQLhastooffer,guidingyou,step-by-step,alongthepathtomastery.ShelveinDatabases/OracleUserlevel:Beginning–AdvancedSOURCECODEONLINEwww.apress.comForyourconvenienceApresshasplacedsomeofthefrontmattermaterialaftertheindex.PleaseusetheBookmarksDown

6、loadfromWow!eBookandContentsataGlancelinkstoaccessthem.ContentsataGlanceAbouttheAuthors...................................................................................................xviiAbouttheTechnicalReviewers.................................

7、...............................................xxIntroduction.............................................................................................................xxi■Chapter1:DoNotUse............................................................................

8、..................1■Chapter2:DynamicSQL:HandlingtheUnknown..................................................19■Chapter3:PL/SQLandPa