Melanie Caffrey

Douglas Scherer

Empty Box

Michael Rosenblum

Sue Harper

Riyaj Shamsudeen

Connor McDonald

John Beresniewicz

Dominic Delmolino

Lewis Cunningham

Torben Holm

Robyn Sands

Ron Crisco

Martin Bchi

Adrian Billington

Stephan Petit

Arup Nanda

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

for Oracle Developers and DBAs

Expert PL/SQL Practices

Tim Gorman

Inger Jorgensen

Lex deHaan

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you’ll learn Create database tables and define their relationships. Add data to your tables. Then change and delete that data. Write database queries that generate accurate results. Avoid common traps and pitfalls in writing SQL queries, especially from nulls. Reap the performance and expressiveness of analytic and window functions. Make use of Oracle Database's support for object types. Write recursive queries to query hierarchical data. Who this book is for Beginning Oracle SQL is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed. Table of Contents 1. Relational Database Systems and Oracle 2. Introduction to SQL and SQL*Plus, and SQL Developer 3. Data Definition, Part I 4. Retrieval: The Basics 5. Retrieval: Functions 6. Data Manipulation 7. Data Definition, Part II 8. Retrieval: Joins and Grouping 9. Retrieval: Advanced Features 10. Views 11. Automating 12. Object-Relational Features 13. Appendix A – Case Tables 14. Appendix B – Exercise Solutions

For Oracle Database 12c

Beginning Oracle SQL

Solomon Morse

Benjamin Rosenzweig

Susan Boardman

Learn to use Oracle 9i to build dynamic, data-driven Web sites. Get step-by-step details on creating and deploying Web applications using PL/SQL, HTML, Java, XML, WML, Peri and PHP. This book covers everything users need to know to master Web application development in an Oracle environment - using PL/SQL.

Oracle Web Application Programming for PL/SQL Developers

Melanie Caffrey

About

Books

Join the club