Effective SQL: 61 Specific Ways to Write Better SQL (Effective Software Development Series)
Oracle Books
Pro Oracle Database 12c Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down …
This book is the first of its kind, a book dedicated to tuning the Oracle high availability RAC architecture. Oracle RAC databases are flexible and robust, and along with this flexibility comes complexity, making RAC tuning one of the most challenging areas of Oracle tuning. Packed with incisive insights and examples from one of America’s leading RAC experts, …
Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the …
Oracle E-Business Suite Development & Extensibility Handbook (Oracle Press)
Extend and Customize Oracle E-Business SuiteTransform your Oracle E-Business Suite infrastructure to suit enterprise requirements using the comprehensive development methods in this Oracle Press guide. Oracle E-Business Suite Development & Extensibility Handbook lays out each tool alongside reusable code and step-by-step examples. Learn how to create multiorg objects, integrate Java and PL/SQL, design custom user interfaces, and use …
SQLLoader is a ubiquitous tool in the Oracle world. It has been shipped with Oracle since at least Version 6 and continues to be supported and enhanced with each new version of Oracle, including Oracle8 and Oracle8i. The job of SQLLoader is to load data from flat files into an Oracle database. It’s optimized for loading large volumes …
Focusing on standard ANSI SQL with a learn-by-doing approach, this book organizes SQL subtopics into short chapters. Readers first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. Provides additional examples of the supplemental commands provided in the Oracle implementation of SQL. Ensures …
Oracle Database 18c: New Features: New Features for DBAs and Developers
Written by Oracle Certified Master Skant Gupta describes the myriad new and enhanced capabilities available in the latest Oracle Database release. This book is meticulously planned for the audience keen to learn all about the amazing new features being offered by Oracle Database 18c. You must have some prior experience of working with Oracle 12c to leverage the …
Running Applications on Oracle Exadata: Tuning Tips & Techniques
Maximize Application Performance on Oracle Exadata Written by an enterprise architect specializing in applications on Oracle’s engineered systems, Running Applications on Oracle Exadata: Tuning Tips & Techniques reveals proven methods for configuring and tuning Oracle Exadata to achieve peak results from applications. You’ll get complete details on application migration, consolidation, and administration. Deliver unparalleled enterprise application performance on …
This book covers Oracle Database 11g, Oracle Database 12c, MySQL and Microsoft SQL Server. It includes related Oracle Database features for readers trying to prototype or implement Oracle GoldenGate. What you will learn from the book? Oracle GoldenGate fundamentals, modular architecture, flexible and scalable configuration and installation options. This is the foundation for all new Oracle GoldenGate users. …