Ebook: Expert PL/SQL Practices: for Oracle Developers and DBAs
- Genre: Computers // Databases
- Tags: Database Management, Programming Languages Compilers Interpreters
- Year: 2011
- Publisher: Apress
- Edition: 1
- Language: English
- pdf
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/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/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/SQL as a powerful and scalable programming language for deploying logic inside the database engine
Content:
Front Matter....Pages i-xxii
Do Not Use....Pages 1-18
Dynamic SQL: Handling the Unknown....Pages 19-43
PL/SQL and Parallel Processing....Pages 45-70
Warnings and Conditional Compilation....Pages 71-96
PL/SQL Unit Testing....Pages 97-120
Bulk SQL Operations....Pages 121-169
Know Your Code....Pages 171-212
Contract-Oriented Programming....Pages 213-233
PL/SQL from SQL....Pages 235-289
Choosing the Right Cursor....Pages 291-312
PL/SQL Programming in the Large....Pages 313-366
Evolutionary Data Modeling....Pages 367-394
Profiling for Performance....Pages 395-423
Coding Conventions and Error Handling....Pages 425-443
Dependencies and Invalidations....Pages 445-474
Back Matter....Pages 475-490
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/SQL as a powerful and scalable programming language for deploying logic inside the database engine
Content:
Front Matter....Pages i-xxii
Do Not Use....Pages 1-18
Dynamic SQL: Handling the Unknown....Pages 19-43
PL/SQL and Parallel Processing....Pages 45-70
Warnings and Conditional Compilation....Pages 71-96
PL/SQL Unit Testing....Pages 97-120
Bulk SQL Operations....Pages 121-169
Know Your Code....Pages 171-212
Contract-Oriented Programming....Pages 213-233
PL/SQL from SQL....Pages 235-289
Choosing the Right Cursor....Pages 291-312
PL/SQL Programming in the Large....Pages 313-366
Evolutionary Data Modeling....Pages 367-394
Profiling for Performance....Pages 395-423
Coding Conventions and Error Handling....Pages 425-443
Dependencies and Invalidations....Pages 445-474
Back Matter....Pages 475-490
....