شیوه‌های کارشناسی PL/SQL: برای توسعه‌دهندگان و DBAهای اوراکل

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#x92;ll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you#x92;ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You#x92;ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle#x92;s world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQL as a powerful and scalable programming language for deploying logic inside the database engine.

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 strong belief that what they share can make a positive difference in the quality and scalability of code that you write.

The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you’ve reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You’ll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects.

These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle’s world-class language for the database engine.

• Goes beyond the manual to cover good techniques and best practices
• Delivers knowledge usually gained only by hard experience
• Covers the functionality that distinguishes PL/SQLas apowerful andscalable programming language for deploying logic inside the database engine

What you’ll learn

• Learn when PL/SQL is best used, and when to avoid it
• Move data efficiently using bulk SQL operations
• Write code that scalesthrough pipelining, parallelism, and profiling
• Choose the right PL/SQL cursor type for any given application
• Reduce coding errors through sound development practices such as unit-testing
• Create and execute SQL and PL/SQL dynamically at runtime

Who this book is for

Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle’s class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language.

Table of Contents

1. Do Not Use
2. Dynamic SQL: Handling the Unknown
3. PL/SQL and Parallel Processing
4. Warnings and Conditional Compilation
5. PL/SQL Unit Testing
6. Bulk SQL Operations
7. Know Your Code
8. Contract-Oriented Programming
9. PL/SQL from SQL
10. Choosing the Right Cursor
11. PL/SQL Programming in the Large
12. Evolutionary Data Modeling
13. Profiling for Performance
14. Coding Conventions and Error Handling
15. Dependencies and Invalidations

Annotation Expert PL/SQL Practicesis 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 youll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If youve reached that point with PL/SQL, then let the authors ofExpert PL/SQL Practicesshow you how to combine syntax and mechanics with features and techniques to really make the language sing. Youll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. LetExpert PL/SQL Practicesopen your eyes to the full power of Oracles world-class language for the database engine. Goes beyond the manual to cover good techniques and best practicesDelivers knowledge usually gained only by hard experienceCovers the functionality that distinguishes PL/SQLas apowerful andscalable programming language for deploying logic inside the database engineWhat youll learnLearn when PL/SQL is best used, and when to avoid itMove data efficiently using bulk SQL operationsWrite code that scalesthrough pipelining, parallelism, and profilingChoose the right PL/SQL cursor type for any given applicationReduce coding errors through sound development practices such as unit-testingCreate and execute SQL and PL/SQL dynamically at runtimeWho this book is forExpert PL/SQL Practicesis for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracles class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. Table of ContentsDo Not UseDynamic SQL: Handling the UnknownPL/SQL and Parallel ProcessingWarnings and Conditional CompilationPL/SQL Unit TestingBulk SQL OperationsKnow Your CodeContract-Oriented ProgrammingPL/SQL from SQLChoosing the Right CursorPL/SQL Programming in the LargeEvolutionary Data ModelingProfiling for PerformanceCoding Conventions and Error HandlingDependencies and Invalidations