Resilient Oracle PL/SQL (eBook)

As legacy and other critical systems continue to migrate online, the need for continuous operation is imperative. Code has to handle data issues as well as hard external problems today, including outages of networks, storage systems, power, and ancillary systems. This practical guide provides system administrators, DevSecOps engineers, and cloud architects with a concise yet comprehensive overview on how to use PL/SQL to develop resilient database solutions.Integration specialist Stephen B Morris helps you understand the language, build a PL/SQL toolkit, and collect a suite of reusable components and patterns. You'll dive into the benefits of synthesizing the toolkit with a requirements-driven, feature-oriented approach and learn how to produce resilient solutions by synthesizing the PL/SQL toolkit in conjunction with a scale of resilience.Build solid PL/SQL solutions while avoiding common PL/SQL antipatternsLearn why embedding complex business logic in SQL is often a brittle propositionLearn how to recognize and improve weak PL/SQL codeVerify PL/SQL code by running data-driven, in-database testsUnderstand the safe operation, maintenance, and modification of complex PL/SQL systemsLearn the benefits of thinking about features rather than just use casesDefine good requirements for PL/SQL and hybrid solutions involving PL/SQL and high level languages