Expert PL/SQL practices for Oracle developers and DBAs
Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you’ll face as a PL/SQL programmer. Each author has chosen their topic out of the str...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
[Berkeley, Calif.] :
Apress
c2011.
|
| Edición: | 1st ed. 2011. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628230506719 |
Tabla de Contenidos:
- Title Page; Copyrigt Page; Contents at a Glance; Table of Contents; About the Authors; About the Technical Reviewers; Introduction; CHAPTER 1 Do Not Use; Row-by-Row Processing; Nested Row-by-Row Processing; Lookup Queries; Excessive Access to DUAL; Arithmetics with Date; Access to Sequences; Populating Master-Detail Rows; Excessive Function Calls; Unnecessary Function Execution; Costly Function Calls; Database Link Calls; Excessive Use of Triggers; Excessive Commits; Excessive Parsing; Summary; CHAPTER 2 Dynamic SQL: Handling the Unknown; The Hero; Native Dynamic SQL; Dynamic Cursors
- DBMS_SQLSample of Dynamic Thinking; Security Issues; Performance and Resource Utilization; Anti-Patterns; Comparing Implementations of Dynamic SQL; Object Dependencies; Negative Effects; Positive Effects; Summary; CHAPTER 3 PL/SQL and Parallel Processing; Why Parallel Processing?; Laws Affecting Parallel Processing; The Rise of Big Data; Parallel vs. Distributed Processing; Parallel Hardware Architectures; Identify Your Goals; Speedup; Scaling Up; Degree of Parallelism; Candidate Workloads for Parallel Processing; Parallelism and OLTP; Parallelism and Non-OLTP Workloads
- The MapReduce Programming ModelBefore Looking to PL/SQL; Processes Available for Parallel Activities; Using Parallel Execution Servers for MapReduce; Pipelined Table Functions; Guidance; Parallel Pipelined Table Functions Summary; Summary; CHAPTER 4 Warnings and Conditional Compilation; PL/SQL Warnings; Basics; Using Warnings; Promoting Warnings to Errors; Ignoring Warnings; Compilation and Warnings; Final Words on Warnings; Conditional Compilation; Basics; What Part of the Code is Running?; Benefits of Preprocessing Code; Invalidations; Controlling Compilation; Inquiry Variables
- Final Words on Conditional CompilationSummary; CHAPTER 5 PL/SQL Unit Testing; Why Test Your Code?; What Is Unit Testing?; Debugging or Testing?; When Should You Build Tests?; Tools for Building Unit Tests; utPLSQL: Working with Command Line Code; Quest Code Tester for Oracle; Oracle SQL Developer; Preparing and Maintaining the Unit Test Environment; Creating the Unit Test Repository; Maintaining the Unit Test Repository; Importing Tests; Building Unit Tests; Using the Unit Test Wizard; Creating the First Implementation; Adding Startup and Teardown Processes
- Collecting Code Coverage StatisticsSpecifying Parameters; Adding Process Validation; Saving Tests; Debugging and Running Tests; Broadening the Scope of the Tests; Creating Lookup Values; Seeding Test Implementations; Creating a Dynamic Query; Supporting Unit Test Features; Running Reports; Creating a Library of Components; Exporting, Importing, and Synchronizing Tests; Building Suites; Running Tests from the Command Line; Summary; CHAPTER 6 Bulk SQL Operations; The Hardware Store; Setting for the Examples in this Chapter; Bulk Operations in PL/SQL; Getting Started with BULK Fetch
- Three Collection-Style Datatypes
