From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. Youll get details on Oracles optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.

The Ultimate Resource for Developing Error-Free SQL Operations

Create a functional debugging environment to develop Structured Query Language solutions efficiently and troubleshoot SQL statements effectively. Use best practices to help perform maintenance, and to find and fix bugs when they do occur. Explore and familiarize yourself with SQL programming problems, learn to write code that's portable across databases, and realize efficiencies by expressing data in a variety of types. Develop the skills you need to debug SQL, and learn to move deftly and creatively around almost every limitation that SQL imposes on your operating environment.Write trouble-free SQL statements and procedures Optimize SQL statements and avoid problem areas Join and aggregate data and other SQL Select statements Debug and use practical regions and sequences Use and debug arrays, sets, and graphs Understand tree structures and hierarchies Secure data and protect response time Examine the appropriate use of data types Select, insert, update, and delete data using SQL syntax Recognize and mitigate fatal and logical errors Format SQL for single queries or extensive procedures using best practices

The definitive book on Oracle's Rdb database.
Written by a team of bestselling database experts, including a principal product architect, this is unquestionably the definitive book on Oracle's Rdb8, the latest version of the powerful database for advanced enterprise applications. Rdb: A Comprehensive Guide, Third Edition teaches administrators, programmers, database designers and IT managers the critical components and functions of the new version 8 and explains how to develop powerful Rdb8 programs. The book specifically addresses new Rdb8 management, tuning and scalability tools and describes the new Rdb/NT Workbench for Windows NT. No other source gives readers the authoritative and timely information provided by Rdb: A Comprehensive Guide, Third Edition.

Only book on Rdb8
Written by Rdb8 experts from Oracle, including the principal product architect
Explains how to use Rdb8 on both Windows NT and OpenVMS

This book is the definitive guide to SQL*Plus, Oracle's interactive query tool. Despite the wide availability and usage of SQL*Plus, few developers and DBAs know how powerful it really is. This book introduces SQL*Plus, provides a syntax quick reference, and describes how to write and execute script files, generate ad hoc reports, extract data from the database, query the data dictionary tables, use the SQL*Plus administrative features (new in Oracle8i), and much more.

This book looks thoroughly at the field of Oracle relational database design, an often neglected area of Oracle, but one that has an enormous impact on the ultimate power and performance of a system. Focuses on both database and code design, including such special design areas as data models, denormalization, the use of keys and indexes, temporal data, special architectures (client/server, distributed database, parallel processing), and data warehouses.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Maximize Oracle Exadata CapabilitiesLeverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage Servers Deploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine

This new edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. The book is targeted at those who are new to APEX and just beginning to develop real projects for production deployment. Reading the book and working the examples will leave you in a good position to build good-looking, highly-functional, web applications. Topics include: conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and updatable reports. Accompanying the book is a demo web application that illustrates each concept mentioned in the book. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 5 Application Development is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications. Teaches how to develop non-trivial APEX applications. Provides deep understanding of APEX functionality. Shows the techniques needed for customization.

Master the multitenant features of Oracle Database 12c Maintain a scalable, highly available enterprise computing platform and dramatically reduce complexity by learning to leverage the powerful new multitenant tools and cloud enhancements available in Oracle Database 12c. You will get hands-on, detailed coverage of key areas such as installation, creation, configuration, and day-to-day administration. Oracle Database 12c Release 2 Multitenant teaches, step-by-step, how to implement and manage multitenant configurations across IT frameworks of all types and sizes. Special attention is given to new features built for both public and private clouds, including Database as a Service (DBaaS) functionality and cloud-based security. Advanced topics are also fully explained, including backup and recovery, data guard, flashback, and resource manager. * Provides targeted best practices and tips for effective administration * Offers start-to finish coverage of both simple and complex installations * Authored by a team of Oracle Masters with a combined 40+ years of experience

Proven database optimization solutions-fully updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips & Techniques thoroughly explains the latest monitoring, troubleshooting, and optimization methods. You will find out how to find and fix bottlenecks, configure storage devices, use Oracle Enterprise Manager, and develop and execute effective queries. Start-to-finish instruction is provided for writing faster, cleaner SQL and PL/SQL code and building radically more efficient, secure, and durable systems. In-depth details throughout highlight new options available for tuning both Oracle Database 12c and 12c Release 2. Testing, reporting, and security enhancements are also covered in this hands-on guide from Oracle Press. * Covers all of the new features in Oracle Database 12c Release 2 * Offers expert advice, proven strategies, and detailed examples * Written by an Oracle Certified Master, highly-respected speaker, and bestselling author

Master Oracle Database 12c Release 2's powerful In-Memory option Maximize database performance and dramatically cut transaction processing time using Oracle Database 12c Release 2's In-Memory feature and the detailed instruction and best practices offered in this Oracle Press guide. You will discover how to exponentially improve efficiency and enable smarter, faster, more informed business decisions enterprise-wide. Oracle Database 12c Release 2 In-Memory: Tips and Techniques for Maximum Performance starts by teaching, step-by-step, how to configure the software and construct In-Memory enabled databases. From there, you will discover how to deliver optimized analytics, use In-Memory Advisor, effectively secure mission-critical data, and distribute real-time, actionable business intelligence. This hands-on resource also provides thorough coverage of Oracle Real Application Clusters and Oracle Multitenant integration. * Offers proven implementation tips drawn from the author's experience * Features real-life case studies not available elsewhere * Written by an Oracle enterprise architect and well-known speaker

Master Oracle Fusion General Ledger and Fusion Financials Accounting Hub Maintain a centralized, highly automated financial processing platform across your organization using Oracle Fusion Applications General Ledger and Financial Accounting Hub. This hands-on Oracle Press guide thoroughly explains the deployment process and illustrates every technique through a start-to-finish case study. Find out how to plan and carry out an end-to-end implementation, integrate data from disparate sources, build budgets and journals, handle ledger and subledger accounting, and distribute mission-critical information through reports and dashboards. Implementing Oracle Fusion Applications General Ledger & Financials Accounting Hub offers complete coverage of security, auditing, and consolidation. * Explore the capabilities of Oracle Fusion Applications General Ledger and Financials Accounting Hub * Configure, perform, and track a new implementation * Construct enterprise and financials reporting structures * Work with currencies, calendars, budgets, ledgers, and journals * Secure your system through authentication and authorization * Meet your enterprise's consolidation and elimination requirements * Transform and load data from external applications * Handle General Ledger revaluation, allocation, and period close * Build feature-rich financial reports and analysis dashboards

Deliver continuous access to timely and accurate BI across your enterprise using the detailed information in this Oracle Press guide. Through clear explanations and practical examples, a team of Oracle experts shows how to assimilate data from disparate sources into a single, unified view. Find out how to transform data in real time, handle replication and migration, and deploy Oracle Data Integrator and Oracle GoldenGate. Oracle Data Integration: Tools for Harnessing Data offers complete coverage of the latest "big data" hardware and software solutions. * Efficiently move data both inside and outside an Oracle environment* Map sources to database fields using Data Merge and ETL * Export schema through transportable tablespaces and Oracle Data Pump* Capture and apply changes across heterogeneous systems with Oracle GoldenGate* Seamlessly exchange information between databases using Oracle Data Integrator* Correct errors and maximize quality through data cleansing and validation* Plan and execute successful Oracle Database migrations and replications* Handle high-volume transactions with Oracle Big Data Appliance, Oracle NoSQL, and third-party utilities

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle SOA Suite 12cDesign, implement, manage, and maintain a highly flexible service-oriented computing infrastructure across your enterprise using the detailed information in this Oracle Press guide. Written by an Oracle ACE director, Oracle SOA Suite 12c Handbook uses a start-to-finish case study to illustrate each concept and technique. Learn expert techniques for designing and implementing components, assembling composite applications, integrating Java, handling complex business logic, and maximizing code reuse. Runtime administration, governance, and security are covered in this practical resource. Get started with the Oracle SOA Suite 12c development and run time environment Deploy and manage SOA composite applications Expose SOAP/XML REST/JSON through Oracle Service Bus Establish interactions through adapters for Database, JMS, File/FTP, UMS, LDAP, and Coherence Embed custom logic using Java and the Spring component Perform fast data analysis in real time with Oracle Event Processor Implement Event Drive Architecture based on the Event Delivery Network (EDN) Use Oracle Business Rules to encapsulate logic and automate decisions Model complex processes using BPEL, BPMN, and human task components Establish KPIs and evaluate performance using Oracle Business Activity Monitoring Control traffic, audit system activity, and encrypt sensitive data

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Design Databases with Oracle SQL Developer Data ModelerIn this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design using Oracle SQL Developer Data Modeler-the powerful, free tool that flawlessly supports Oracle and other database environments, including Microsoft SQL Server and IBM DB2. Oracle SQL Developer Data Modeler for Database Design Mastery covers requirement analysis, conceptual, logical, and physical design, data warehousing, reporting, and more. Create and deploy high-performance enterprise databases on any platform using the expert tips and best practices in this Oracle Press book. Configure Oracle SQL Developer Data Modeler Perform requirement analysis Translate requirements into a formal conceptual data model and process models Transform the conceptual (logical) model into a relational model Manage physical database design Generate data definition language (DDL) scripts to create database objects Design a data warehouse database Use subversion for version control and to enable a multiuser environment Document an existing database Use the reporting tools in Oracle SQL Developer Data Modeler Compare designs and the database

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. This authoritative Oracle Press resource on RMAN has been thoroughly revised to cover every new feature, offering the most up-to-date information This fully updated volume lays out the easiest, fastest, and most effective methods of deploying RMAN in Oracle Database environments of any size. Keeping with previous editions, this book teaches computing professionals at all skill levels how to fully leverage every powerful RMAN tool and protect mission-critical data. Oracle Database 12c RMAN Backup and Recovery explains how to generate reliable archives and carry out successful system restores. You will learn to work from the command line or GUI, automate the database backup process, perform Oracle Flashback recoveries, and deploy third-party administration utilities. The book features full details on cloud computing, report generation, performance tuning, and security. Offers up-to-date coverage of Oracle Database 12c new features Examples and workshops throughout walk you through important RMAN operations

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. The Most Complete, Current Oracle DBA ResourceMaintain a high-performance Oracle Database using the best practices and expert techniques in this Oracle Press guide. Oracle Database 12c DBA Handbook is thoroughly updated to cover the new features and utilities, including the multitenant architecture, Oracle Database In-Memory option, and cloud enhancements. Real-world examples for every major configuration are included. You'll learn how to successfully manage a highly available, robust, secure, and extensible Oracle enterprise database environment. Upgrade to Oracle Database 12c Plan and manage tablespaces Maximize database performance using effective physical database layouts and storage management methods Monitor disk space used by database objects Manage transactions with undo tablespaces Implement expert performance-tuning techniques Increase query speed using the new Oracle Database In-Memory option Manage database security through authentication, authorization, and auditing Take full advantage of the multitenant database architecture Enable high availability and scalability with Oracle Real Application Clusters and Oracle Active Data Guard Perform backup and recovery with Oracle Recovery Manager Manage distributed databases and VLDBs

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Design and Deliver Effective Visual Solutions of BI DataCowritten by an Oracle ACE Director and an expert in data visualization design specializing in BI and analytics, Data Visualization for Oracle Business Intelligence 11g reveals best practices for presenting data-driven insights with graphs, tables, maps, dashboards, and other methods that will immediately enhance corporate decision-making. Throughout the book, the principles of effective design are emphasized. Leverage the power of this comprehensive business intelligence platform to deliver rich visualizations of business information across the enterprise. Create well-organized tables and pivot tables Convey data insights with line, bar, pie, waterfall, radar, and other graphs Configure MapViews so that you can provide interactive maps and spatial analysis capabilities Build advanced visualizations, including trellis charts, gauges, R images, jQuery sparklines, and more Use Oracle Business Intelligence Publisher to create pixel-perfect reports from various data sources Design effective, interactive BI dashboards Use the Oracle Scorecard and Strategy Management module to measure, evaluate, and manage key performance indicators Make smart color choices using data science tools

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Build Next-Generation In-Database Predictive Analytics Applications with Oracle Data Miner"If you have an Oracle Database and want to leverage that data to discover new insights, make predictions, and generate actionable insights, this book is a must read for you! In Predictive Analytics Using Oracle Data Miner: Develop & Use Oracle Data Mining Models in Oracle Data Miner, SQL & PL/SQL, Brendan Tierney, Oracle ACE Director and data mining expert, guides you through the basic concepts of data mining and offers step-by-step instructions for solving data-driven problems using SQL Developer's Oracle Data Mining extension. Brendan takes it full circle by showing you how to deploy advanced analytical methodologies and predictive models immediately into enterprise-wide production environments using the in-database SQL and PL/SQL functionality. Definitely a must read for any Oracle data professional!" --Charlie Berger, Senior Director Product Management, Oracle Data Mining and Advanced Analytics Perform in-database data mining to unlock hidden insights in data. Written by an Oracle ACE Director, Predictive Analytics Using Oracle Data Miner shows you how to use this powerful tool to create and deploy advanced data mining models. Covering topics for the data scientist, Oracle developer, and Oracle database administrator, this Oracle Press guide shows you how to get started with Oracle Data Miner and build Oracle Data Miner models using SQL and PL/SQL packages. You'll get best practices for integrating your Oracle Data Miner models into applications to automate the discovery and distribution of business intelligence predictions throughout the enterprise. Install and configure Oracle Data Miner for Oracle Database 11g Release 11.2 and Oracle Database 12c Create Oracle Data Miner projects and workflows Prepare data for data mining Develop data mining models using association rule analysis, classification, clustering, regression, and anomaly detection Use data dictionary views and prepare your data using in-database transformations Build and use data mining models using SQL and PL/SQL packages Migrate your Oracle Data Miner models, integrate them into dashboards and applications, and run them in parallel Build transient data mining models with the Predictive Queries feature in Oracle Database 12c

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Maximize the New and Improved Features of Oracle Database 12cWritten by Master Principle Database Expert, Oracle, and Oracle ACE Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you'll find everything you need to know to get up and running quickly on Oracle Database 12c. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12c Architectural changes, such as Oracle Multitenant The most current information on upgrading and migrating to Oracle Database 12c The pre-upgrade information tool and parallel processing for database upgrades Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System Oracle RMAN enhancements, including cross-platform backup and recovery Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync SQL, PL/SQL, DML, and DDL new features Improvements to partitioning manageability, performance, and availability Advanced business intelligence and data warehousing capabilities Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges Manageability, performance, and optimization improvements

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Implement Oracle Business Intelligence ApplicationsProvide actionable business intelligence across the enterprise to enable informed decision-making and streamlined business processes. Oracle Business Intelligence Applications: Deliver Value Through RapidImplementations shows how to justify, configure, customize, and extend this complete package of BI solutions. You'll get a technical walkthrough of Oracle Business Intelligence Applications architecture--from thedashboard to the data source--followed by best practices for maximizing the powerful features of each application. You will also find out about stakeholders critical to project approval and success. Optimize performance using Oracle Exalytics In-Memory Machine Deliver timely financial information to managers with Oracle Financial Analytics Enable a streamlined, demand-driven supply chain viaOracle Supply Chain and Order Management Analytics Provide end-to-end visibility into manufacturing operations with Oracle Manufacturing Analytics Optimize supply-side performance through Oracle Procurement and Spend Analytics Use Oracle Human Resources Analytics to provide key workforce information to managers and HR professionals Track the costs and labor required to maintain and operate assets with Oracle Enterprise Asset Management Analytics Maintain visibility into project performance via Oracle Project Analytics Provide actionable insight into sales opportunities using Oracle Sales Analytics Enable superior customer service with Oracle Service Analytics

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.Master Oracle Database 12c PL/SQL Application DevelopmentDevelop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master the Combined Analysis Tools in Oracle CRM on DemandDrive better decision-making across your enterprise using the reporting and analysis techniques in this Oracle Press guide. Through clear explanations and detailed case studies, Oracle CRM on Demand Combined Analyses shows you how to deliver real-time insightful business intelligence to end users. Learn how to perform multiple queries, join tables, format result columns, and add interactivity to your reports. Methods for filtering the results of a combined analysis are also covered in this practical resource. Create, edit, and join reports with set operators in Oracle Answers On Demand Configure roles and privileges to allow access to development tools Use negative reporting methods to compensate for null data Analyze records from the transactional databases and data warehouse in federated reports Add advanced views such as gauges, view selectors, funnel charts, and narrative views to your combined reports Integrate ad hoc analysis using Oracle Answers on Demand Consolidate information from disparate sources with pivot tables Perform calculations across multiple reports using result columns

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Achieve Extreme Application Performance for a Private Cloud with Oracle Exalogic Elastic Cloud Transition to a private cloud computing infrastructure and achieve unmatched levels of performance with help from this Oracle Press guide. Oracle Exalogic Elastic Cloud Handbook shows you how to plan, implement, and maintain a private cloud. Find out how to set up components, deploy Java applications, maximize redundancy and throughput, and migrate legacy workloads. Examples, screenshots, and diagrams are included throughout this comprehensive resource. Configure Oracle Exalogic Elastic Cloud nodes and racks Optimize Java EE application performance on Oracle WebLogic Server Provision and administer a highly scalable private cloud Build, debug, and manage custom Java applications Secure, monitor, and tune using Oracle Enterprise Manager Leverage capabilities from Oracle Fusion Middleware Consolidate Oracle and third-party application workloads

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle Data Guard 11g Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download. Develop a disaster recovery plan for your Oracle database to meet your organization's requirements Configure and deploy Oracle Data Guard for your environment Tune and troubleshoot your physical and logical standby databases Implement the Oracle Data Guard Broker management framework Integrate with Oracle Grid Control Monitor your Oracle Data Guard environment Enable read-only services and disaster recovery with Oracle Active Data Guard Configure seamless database and application failover Minimize planned downtime using Oracle Data Guard switchover Handle backup and recovery with Oracle Recovery Manager

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Master Oracle E-Business Suite's Oracle General Ledger Maintain a centralized, highly automated processing platform across a fully integrated set of Oracle E-Business Suite applications using Oracle General Ledger. This Oracle Press guide explains how to utilize Oracle General Ledger to distribute timely and accurate financial information enterprise-wide. Learn efficient techniques for creating transactions and budgets, defining custom rules and flows, reconciling balances, and easing regulatory compliance. You will also discover how to consolidate financial data, process foreign currencies, and implement the brand-new Oracle Subledger Accounting. Plan, test, and carry out a new implementation or upgrade Work with ledgers, calendars, journals, budgets, and business flows Convert and load data from external systems and spreadsheets Perform company-wide consolidations Render reports using the Financial Statement Generator Handle foreign transactions, translations, and revaluations Centralize accounting rules using Oracle Subledger Accounting Understand implications of setup and implementation decisions