Now you can master the latest version of the fundamental SQL language used in all relational databases today with ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps you transform a basic knowledge of databases into proficiency with the latest SQL and Oracle concepts and techniques. You learn to use Oracle 12c SQL most effectively as you prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, manipulating data, and more. The author then explores both basic data query techniques as well as advanced query topics using a proven hands-on approach. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help you transition to further studies and even more advanced books in this series, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Trust ORACLE 12C: SQL, 3E to provide the knowledge you need for Oracle certification testing and the solid foundation for pursuing a career as a database administrator or developer.

When Prometheus stole the sacred Olympian flame and bestowed it upon humanity, he literally sparked the growth of civilization. Now Prometheus presents us with a different but no less significant gift: the guiding flame of insight, drawn from the stories and energies of the kings, gods, and heroes who complement history and mythology's great queens, goddesses, and heroines. This rich and lovely 50-card oracle deck and guidebook unifies male energies with those of the Chakras to create a unique and fresh approach to personal divination. You will be led by warriors like Odysseus, cunning kings like Hammurabi, quiet prophets like Elijah, and monsters like Pazuzu to strong intuitive wisdom that can be applied to your well-being and life's serious and day-to-day issues. The evocative portrait cards, each featuring a Chakra will, like Prometheus, bring the fire of knowledge and renewal to your soul.

OCS is becoming the dominant product for large-scale collaborationblending core functions of e-mail, file serving, and diary management with the additional functionality of web conferencing, instant messaging, and wireless access. Pro Oracle Collaboration Suite 10g provides all you need to know to install and configure OCS for use, but this book is much more than a to-do list.

It covers the architecture of the server processes and the applications, giving you the theoretical background to take OCS beyond the basics. Theres no need to worry if youre new to the Oracle database, Oracle Components for Java environment (OC4J), HTTP web servers, or LDAP Internet directorieseverything is explained carefully. But if you are already familiar with these topics, youll learn how to fully exploit them in order to optimize your OCS installation.

"JDBC Metadata, MySQL, and Oracle Recipes" is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the authors other book, "JDBC Recipes: A Problem-Solution Approach," leaves off.

This edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developer's application development.

"The book...has enough depth for even a seasoned professional to pick up enough tips to pay back the price of the book many times over." -Dr. Paul Dorsey, President, Dulcian, Inc., Oracle Magazine PL/SQL Developer of the Year 2007, and President Emeritus, New York Oracle Users Group "This is a fascinating guide into the world of Oracle SQL with an abundance of well-collected examples. Without a doubt, this book is helpful to beginners and experts alike who seek alternative ways to resolve advanced scenarios."-Oleg Voskoboynikov, Ph.D., Database Architect The World's #1 Hands-On Oracle SQL Workbook-Fully Updated for Oracle 11g Crafted for hands-on learning and tested in classrooms worldwide, this book illuminates in-depth every Oracle SQL technique you'll need. From the simplest query fundamentals to regular expressions and with newly added coverage of Oracle's powerful new SQL Developer tool, you will focus on the tasks that matter most. Hundreds of step-by-step, guided lab exercises will systematically strengthen your expertise in writing effective, high-performance SQL. Along the way, you'll acquire a powerful arsenal of useful skills-and an extraordinary library of solutions for your real-world challenges with Oracle SQL. Coverage includes 100% focused on Oracle SQL for Oracle 11 g, today's #1 database platform-not "generic" SQL! Master all core SQL techniques including every type of join such as equijoins, self joins, and outer joins Understand Oracle functions in depth, especially character, number, date, timestamp, interval, conversion, aggregate, regular expressions, analytical, and more Practice all types of subqueries, such as correlated and scalar subqueries, and learn about set operators and hierarchical queries Build effective queries and learn fundamental Oracle SQL Developer and SQL*Plus skills Make the most of the Data Dictionary and create tables, views, indexes, and sequences Secure databases using Oracle privileges, roles, and synonyms Explore Oracle 11 g's advanced data warehousing features Learn many practical tips about performance optimization, security, and architectural solutions Avoid common pitfalls and understand and solve common mistakes For every database developer, administrator, designer, or architect, regardless of experience!

If you are a typical Oracle professional, you don't have the luxury of time to keep up with new technology and read all the new manuals to understand each new feature of the latest release from Oracle. You need a comprehensive source of information and in-depth tips and techniques for using the new technology. You need Oracle Internals: Tips, Tricks, and Techniques for DBAs.
Oracle has evolved from a simple relational database into one of the most complex e-commerce platforms ever devised. It's not enough for you to understand just the Oracle database. You must also understand the components of the Web server technology, XML, Oracle Security, Oracle and Java, and a host of other issues in order to do your job properly.
This book is a compendium of the best and most useful articles form Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators and other Oracle professionals. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information not found in any other book, information only available from peers and consultants. The chapters focus on the truly tough stuff - proven techniques learned in the trenches.
You could get this information from other sources, but you'd have to hunt and peck for it. Can you afford that kind of time? Oracle Internals: Tips, Tricks, and Techniques for DBAs gives you knowledge and advice directly applicable to your work in one easy-to-use resource.

When your database application isn't running fast enough, troubleshooting is usually your first move. Finding the slow part of an application is often easy, but discovering a solution can prove much more difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance. Written for developers by an application developer who has learned by doing, this book shows you how to plan for performance as you would for any other application requirement.

The popularity of object-oriented concepts, design, and programming has stimulated the need for a database system that enables a straightforward process to store and retrieve object instances. Object-Oriented Oracle explores object-oriented features and techniques in Oracle DBMS. This book describes comprehensive and fundamental aspects of object-oriented data modeling and implementation in Oracle. It covers the implementation of structural aspects of an object model, including object types, collection types, object referencing, nested tables, and inheritance structures, as well as the behavioral aspects including encapsulated member procedures and functions. Object-Oriented Oracle discusses the complete cycle of database design using object-oriented concepts, implementation of object-relational Oracle, and data manipulations using member procedures/functions and object-relational queries. Object-Oriented Oracle contains a wealth of information, such as case studies in every chapter, as well as exercises at the end of each chapter which helps readers to absorb the topics better, all reasons this book is a necessary collection addition for academics, researchers, educators, and IT professionals everywhere.

Oracle Database Programming with Visual Basic.NET Discover a detailed treatment of the practical considerations and applications of Oracle database programming with Visual Basic 2019 Oracle Database Programming with Visual Basic.NET: Concepts, Designs, and Implementations delivers a comprehensive exploration of the foundations of Oracle database programming using Visual Basic.NET. Using Visual Basic.NET 2019, Visual Studio.NET 2019, and Oracle 18c XE, the book introduces the Oracle database development system, Oracle SQL Developer and Modeler, and teaches readers how to implement a sample database solution. The distinguished author also demonstrates the use of dotConnect for Oracle to show readers how to create an effective connection to an Oracle 18c XE database. The current versions of the .NET framework, ASP.NET, and ASP.NET 4.7 are also explored and used to offer readers the most up to date web database programming techniques available today. The book provides practical example projects and detailed, line-by-line descriptions throughout to assist readers in the development of their database programming skill. Students will also benefit from the inclusion of: A thorough introduction to databases, including definitions, examples, descriptions of keys and relationships, and some database components in popular databases, like Access, SQL, and Oracle An exploration of ADO.NET, including its architecture and components, like the DataReader class, DataSet component, DataTable component, and the command and parameter classes A discussion of Language Integrated Query (LINQ), including its architecture and components, its relationship to objects, DataSet, Oracle, and Entities An explanation of how to access data in ASP.NET and ASP.NET Web Services with multiple real project examples. Perfect for college and university students taking courses related to database programming and applications, Oracle Database Programming with Visual Basic.NET will also earn a place in the libraries of programmers and software engineers seeking a comprehensive reference for database coding in Visual Basic.NET.

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place.Application over mathematical proofs...

If you're an IT practioner who appreciates application over mathematical proofs than you'll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda.A practical and hands-on training course in a book...

This book is a kind of training course. After reading, studying, and practicing the material covered in this book, you to be able to confidently, responsibly, and professionally forecast performance and system capacity in a wide variety of real-life situations. How to avoid being on the Wall Street Journal's front page...

If you are more management minded (or want to be) you will be delighted with the service level management focus. Forecasting makes good business sense because it maximizes the return on IT investment and minimizes unplanned down time. To those who think forecasting is a waste of money. Well...obviously they've never been on the evening news because their company lost millions of dollars in revenue and brand destruction because of poorly performing orunavailable systems.It's about equipping you...

Without a doubt you will be equipped to deal with the realities of forecasting Oracle performance. But this book gives you more. Not only will you receive a technical and mathematical perspective, but also a communication, a presentation, and a management perspective. This is career building stuff and immensely satisfying!What you'll learn

This book is a "how to" book filled with examples to transform theory and mathematics into something you can practically apply. You will learn how to use a variety of forecasting models, which will enable you to methodically: Help manage service levels from a business value perspective, Identify the risk of over utilized resources, Predict what component of an architecture is at risk, Predict when a system will be at risk, Develop multiple risk mitigating strategies to ensure service levels aremaintainedCharacterize a complex Oracle workload.Who is this book for?

I.T. professionals who must ensure their production Oracle systems are meeting service levels, in part, through forecasting performance, identifying risk, and developing solutions to ensure systems are available without wasting budget. Readers include database administrators, I.T. managers, developers, capacity planners, systems architects, systems integrators.

In today's competitive marketplace with its focus on profit, maintaining integrity can often be a challenge. Further complicating this challenge is the fact that those assigned to the task of assuring accountability within an organization often have little, if any, visibility into the inner workings of that organization. Oracle Identity Management: Governance, Risk, and Compliance Architecture is the definitive guide for corporate stewards who are struggling with the challenge of meeting regulatory compliance pressures while embarking on the path of process and system remediation. The text is written by Marlin Pohlman, a director with Oracle who is recognized as one of the primary educators worldwide on identity management, regulatory compliance, and corporate governance. In the book's first chapters, Dr. Pohlman examines multinational regulations and delves into the nature of governance, risk, and compliance. He also cites common standards, illustrating a number of well-known compliance frameworks. He then focuses on specific software components that will enable secure business operations. To complete the picture, he discusses elements of the Oracle architecture, which permit reporting essential to the regulatory compliance process, and the vaulting solutions and data hubs, which collect, enforce, and store policy information. Examining case studies from the five most regulated business verticals, financial services, retail, pharma-life sciences, higher education, and the US public sector, this work teaches corporation stewards how to: Attain and maintain high levels of integrity Eliminate redundancy and excessive expense in identity management Map solutions directly to region and legislation Hold providers accountable for contracted services Identity management is the first line of defense in the corporate internal ecosystem. Reconcilingtheory and practicality, this volume makes sure that defense is workable, responsive, and effective.

Database developers and administrators will use this book to learn how to deploy machine learning models in Oracle Database and in Oracle's Autonomous Database cloud offering. The book covers the technologies that make up the Oracle Machine Learning (OML) platform, including OML4SQL, OML Notebooks, OML4R, and OML4Py. The book focuses on Oracle Machine Learning as part of the Oracle Autonomous Database collaborative environment. Also covered are advanced topics such as delivery and automation pipelines. Throughout the book you will find practical details and hand-on examples showing you how to implement machine learning and automate deployment of machine learning. Discussion around the examples helps you gain a conceptual understanding of machine learning. Important concepts discussed include the methods involved, the algorithms to choose from, and mechanisms for process and deployment. Seasoned database professionals looking to make the leap into machine learning as a growth path will find much to like in this book as it helps you step up and use your current knowledge of Oracle Database to transition into providing machine learning solutions. What You Will Learn Use the Oracle Machine Learning (OML) Notebooks for data visualization and machine learning model building and evaluation Understand Oracle offerings for machine learning Develop machine learning with Oracle database using the built-in machine learning packages Develop and deploy machine learning models using OML4SQL and OML4R Leverage the Oracle Autonomous Database and its collaborative environment for Oracle Machine Learning Develop and deploy machine learning projects in Oracle Autonomous Database Build an automated pipeline that can detect and handle changes in data/model performance Who This Book Is For Database developers and administrators who want to learn about machine learning, developers who want to build models and applications using Oracle Database's built-in machine learning feature set, and administrators tasked with supporting applications on Oracle Database that make use of the Oracle Machine Learning feature set

Write queries using little-known, but powerful, SQL features implemented in Oracle's database engine. You will be able to take advantage of Oracle's power in implementing business logic, thereby maximizing return from your company's investment in Oracle Database products. Important features and aspects of SQL covered in this book include the model clause, row pattern matching, analytic and aggregate functions, and recursive subquery factoring, just to name a few. The focus is on implementing business logic in pure SQL, with a comparison of different approaches that can be used to write SELECT statements to return results that drive good decision making and competitive action in the marketplace. This book covers features that are often not well known, and sometimes not implemented in competing products. Chapters on query transformation and logical execution order provide a grasp of the big picture in which the individual SQL features described in the other chapters are executed. Also included are a discussion on when to use the procedural capabilities from PL/SQL, and a series of examples showing different mixes of SQL features being applied in common types of queries that you are likely to encounter. What You Will Learn Gain competitive advantage from Oracle SQL Know when to step up to PL/SQL versus staying in SQL Become familiar with query transformations and join mechanics Apply the model clause and analytic functions to business intelligence queries Make use of features that are specific to Oracle Database, such as row pattern matching Understand the pros and cons of different SQL approaches to solving common query tasks Traverse hierarchies using CONNECT BY and recursive subquery factoring Who This Book Is For Database programmers with some Oracle Database experience. The book is also for SQL developers who are moving to the Oracle Database platform or want to learn unique features of its query engine. Both audiences will learn to apply the full power of Oracle's own SQL dialect to commonly encountered types of business questions and query challenges.

Take the right steps when a breach of your Oracle Database environment becomes known or suspected. You will learn techniques for discerning how an attacker got in, what data they saw, and what else they might have done. This book helps you understand forensics in relation to Oracle Database, and the tools and techniques that should be used to investigate a database breach. You will learn the measures to put in place now to make it harder for an attack to be successful, and to aid in the detection and investigation of future attacks. You will know how to bring together tools and methods to create a holistic approach and investigation when an event occurs, helping you to be confident of your ability to react correctly and responsibly to threats against your organization's data. What You'll Learn Detect when breaches have or may have occurred React with confidence using an organized plan Determine whether a suspected breach is real Determine the scope of data that has been compromised Preserve evidence for possible criminal prosecutions Put in place measures to aid future investigations Who This Book is For Database administrators, system administrators, and other technology professionals who may be called upon to investigate breaches of security involving Oracle Database

Learn the many design decisions that must be made before starting to build a large Oracle Application Express (APEX) application for the cloud or enterprise. One of APEX's key strengths is the fact that it is a Rapid Application Development (RAD) tool. This is also a major weakness when it tempts developers to start coding too soon. Small applications that consist of tens of pages can be coded without a lot of design work because they can be re-factored quickly when design flaws are discovered. Design flaws in large cloud and enterprise applications that consist of hundreds or thousands of pages are not so easy to re-factor due to the time needed to redevelop and retest the application, not to mention the risk of breaking functionality in subtle ways. Designing a large application before coding starts is a profitable exercise because a thoughtful design goes a long way in mitigating cost overruns and schedule slippage while simultaneously enhancing quality. This book takes into account perspectives from other non-developer stakeholders such as maintenance developers, business analysts, testers, technical writers, end users, and business owners. Overlooking these perspectives is one of the chief causes of expensive rework late in the development cycle. Oracle Application Express by Design illustrates APEX design principles by using architecture diagrams, screen shots, and explicit code snippets to guide developers through the many design choices and complex interrelationship issues that must be evaluated before embarking on large APEX projects. This book: Guides you through important, up-front APEX design decisions Helps you to optimize your design by keeping all stakeholders in mind Explicit code examples show how design impacts cost, schedule, and quality What You Will Learn Pick and choose from the list of designs before coding begins Bake optimal quality into the underlying fabric of an APEX application Think and design from outside the developer's narrow perspective Optimize APEX application designs to satisfy multiple stakeholder groups Evaluate design options through hands-on, explicit code examples Define and measure success for large cloud and enterprise APEX applications Who This Book Is For APEX developers and development teams

Quickly get up to speed with Oracle's Application Development Framework (ADF). Rapidly build modern, user-friendly applications that will be easy to re-use, expand, and maintain. Oracle ADF Survival Guide covers the latest 12c version and explains all the important concepts and parts, including ADF Faces, ADF Task Flows, ADF Business Components, ADF Skins, the new Alta UI, and how to implement business logic in all layers of the application. Organizations with existing investments in Oracle database and Oracle Forms applications will be able to leverage Oracle's best practice for application development in moving those applications to the ADF framework. The book: Explains all parts of the ADF stack Shows how to integrate with databases and web services Demonstrates the best practice for ADF enterprise architecture What You Will Learn Rapidly build great-looking, user-friendly screens Build page flows visually for improved communication with business users Easily connect your user interface to databases and other back-end systems Leverage the best practice for productive team development Establish a solid enterprise architecture for maximum reuse and maintainability Automate your build and deployment process Who This Book Is For Experienced developers who want to rapidly become productive with Oracle's Application Development Framework (ADF) 12c. It is for Oracle Forms and database developers working for organizations who have followed Oracle's strategic direction to ADF, as well as for experienced Java developers who want to learn Oracle's highly-productive, JSF framework.

Use machine learning and Oracle Business Intelligence Enterprise Edition (OBIEE) as a comprehensive BI solution. This book follows a when-to, why-to, and how-to approach to explain the key steps involved in utilizing the artificial intelligence components now available for a successful OBIEE implementation. Oracle Business Intelligence with Machine Learning covers various technologies including using Oracle OBIEE, R Enterprise, Spatial Maps, and machine learning for advanced visualization and analytics. The machine learning material focuses on learning representations of input data suitable for a given prediction problem. This book focuses on the practical aspects of implementing machine learning solutions using the rich Oracle BI ecosystem. The primary objective of this book is to bridge the gap between the academic state-of-the-art and the industry state-of-the-practice by introducing you to machine learning with OBIEE. What You Will Learn See machine learning in OBIEE Master the fundamentals of machine learning and how it pertains to BI and advanced analytics Gain an introduction to Oracle R Enterprise Discover the practical considerations of implementing machine learning with OBIEE Who This Book Is For Analytics managers, BI architects and developers, and data scientists.

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this 6th edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 12c, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. It's an indispensable reference for both novices and experienced Oracle programmers.

Master Oracle GoldenGate technology on multiple database platforms using this step-by-step implementation guide. Learn about advanced features to use in building a robust, high-availability replication system. Provided are detailed illustration of Oracle GoldenGate concepts, GoldenGate tools and add-ons, as well as illustrative examples. The book covers Oracle GoldenGate for Oracle database, and also discusses setup and configuration for other common databases such as IBM DB2, SYBASE ASE, MySQL, and Microsoft SQL Server. The technology landscape is fast-changing, and Mastering Oracle GoldenGate stays current by covering the new features included in Oracle GoldenGate 12c. The book covers both classic capture and integrated capture, as well as delivery. Also covered are Oracle GoldenGate security and performance tuning, to keep your system secure and performing at its best. You will learn to monitor your GoldenGate system using tools that come with Oracle GoldenGate management pack, as well as using shell scripts. Troubleshooting is well-illustrated with examples: Covering Oracle GoldenGate technology across common database brands Discussing high-performing and secure replication environments Speaking to replication in Big Data and cloud computing environments What You Will Learn Implement Oracle GoldenGate for real time replication Secure and tune your replication environment for high performance Administer your Oracle GoldenGate environment Learn troubleshooting approaches with help of examples Make use of GoldenGate Management Pack and its API Feed live data into Big Data and cloud-based systems Who This Book Is For Database professionals who have chosen to ride the Oracle GoldenGate roller coaster for real-time replication solutions. The book is for beginners as well as professionals who are willing to master the leading replication technology in the industry. It is an excellent choice for professionals who are implementing or maintaining Oracle GoldenGate replication environments on any of the major database management system platforms.

Speed up the execution of important database queries by making good choices about which indexes to create. Choose correct index types for different scenarios. Avoid indexing pitfalls that can actually have indexes hurting performance rather than helping. Maintain indexes so as to provide consistent and predictable query response over the lifetime of an application. Expert Oracle Indexing and Access Paths is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer. Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Oracle Indexing and Access Paths helps by bringing together information on indexing and how to use it into one blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indexes available and when each is best applied. Recognize when queries aren't using indexes as you intend. Manage your indexing for maximum performance. Confidently use the In Memory column store feature as an alternate access path to improve performance. Let Expert Indexing in Oracle Database 12c be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database. Explains how indexes help performance, and sometimes hinder it too Demystifies the various index choices so that you can chose rightly Describes the database administration chores associated with indexes Demonstrates the use of the In Memory column store as an alternate access path to the data What You Will Learn Create an overall indexing strategy to guide your decisions Choose the correct indexing mechanisms for your applications Manage and maintain indices to avoid degradation and preserve efficiency Take better advantage of underused index types such as index-organized tables Choose the appropriate columns to index, with confidence Blend partitioning and materialized views into your indexing strategy Who This Book Is For All levels of database administrators and application developers who are struggling with the database performance and scalability challenge. Any database administrator involved with indexing, which is any database administrator period, will appreciate the wealth of advice packed into this gem of a book.

Take a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective of GoldenGate from an implementer's viewpoint; however, also addresses why the management viewpoint is important as well. Your journey through this book includes and architecture discussion of GoldenGate and the benefits of purchasing GoldenGate from a management perspective. Then the book quickly moves into advanced implementation components associated with GoldenGate. You'll find many use-cases and instructions throughout the book to help with everything from easy to complex GoldenGate implementations. An Oracle GoldenGate implementation generally consists of a group project, involving both business and technical resources. Pro Oracle GoldenGate for the DBA provides the viewpoint from the DBA's vantage point. This approach provides the components of who, what, why, when, and how in defining the implementation and support of a GoldenGate project. The success of most technical projects require the support of multiple resource groups, and Pro Oracle GoldenGate for the DBA supplies the insight for the DBA member to understand the implementation and support process. Takes you through justification, installation, and support. Provides the DBA perspective toward a successful a result. Covers from basic toward increasingly advanced implementations What You Will Learn Understand the core architecture of data replication using Oracle GoldenGate Implement a one-way setup of a classic capture and an integrated capture and replication Design, architect and implement a multi-master replication model Replicate unsupported data types using tokens Manage and troubleshoot multiple GoldenGate implementations New features of GoldenGate supported in Oracle 12c Who this Book is For Pro Oracle GoldenGate for the DBA is aimed squarely at Oracle database administrators who find themselves involved in GoldenGate integration projects. The book provides the DBA view into such projects, helping database administrators toward successful implementations and solid business results.

Learn the fundamental concepts of OS clustering, Oracle Solaris clustering high-level design, Oracle Solaris clustering implementation using VirtualBox, and Veritas clustering implementation using VirtualBox. Oracle Solaris and Veritas Cluster: An Easy-build Guide shows you how to implement a cluster on your desktop or laptop devices using virtualized network, host, and storage configuration. This book explains both the architecture design and technical implementation for building Solaris Oracle- or Veritas-based clustered environments. This book provides snapshot-based steps to set up Solaris virtual hosts under VirtualBox and implement Veritas clustering across two virtual hosts that can be implemented on a desktop or laptop. This book will help you understand what it's like setting up a clustered environment, in simple steps that can be followed by users having little knowledge of clustering. What You Will Learn: Practice cluster implementation on your local PC or laptop Implement both Oracle/Solaris and Veritas clusters under Oracle Solaris 10 OS Master cluster fundamentals, concepts, and design Create virtualized environments under VirtualBox Learn the prerequisites and configuration for host builds, networking, and storage setup using VirtualBox for Solaris Oracle and Veritas Who This Book Is For: IT support engineers, education institutions and students.

Building on your existing SQL skills, this book teaches you how to apply useful jQuery techniques to applications developed using the Oracle Application Express (APEX) development tool. Pro jQuery in Oracle Application Express covers the fundamentals you need to start enhancing your applications, with some practical examples that you'll want in your own applications tomorrow. jQuery is a framework already utilized by APEX, and by learning the basics of jQuery you can leverage the flexible dynamic actions provide and see your applications raise the bar. Discover why you should embrace HTML5, CSS, and jQuery library capabilities, and how they can enhance the user experience. Oracle Application Express is a mature, browser-based, rapid-development environment with a strong community base around the #orclapex tag. jQuery is a language for the browser, with it you can treat your web page as if it were a database, interacting with a range of features and functions that can make you into a more constructive, more efficient developer. Exemplifies how productive APEX, CSS, and jQuery can be Transforms your PL/SQL skills to CSS and jQuery Provides jQuery snippets to enhance your application UX

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example-based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides instead is task-oriented coverage designed around the needs of the Oracle Database Administrator. Find the right chapter. Look up the task to perform. See the solution. Implement the solution straight away in your own environment. Get the job done. New in this edition is coverage of Oracle's own Solaris operating system. Oracle Corporation has been working diligently to bring commonality between Solaris and and Linux, and this book takes advantage of those efforts to provide task-oriented solutions that work on common distributions of Linux such as Red Hat Enterprise Linux and Oracle Enterprise Linux while also accommodating the growing number of Oracle Solaris customers. Examples in the book match the tasks DBAs perform daily, even hourly. Solutions come first in the book, but alway are followed by close explanations of the details. Database administrators won't go wrong with Linux and Solaris Recipes for Oracle DBAs. It's the book to buy if you're after clear and reliable examples to help in getting the job done, and getting home to your family. Takes you directly from problem to solution Covers the "right" mix of operating-system tasks for database administrators Respects your time by being succinct and to-the-point Includes coverage of Solaris in addition to common Linux distributions What You Will Learn Execute Linux and Solaris commands applicable to Oracle Database. Automate critical DBA tasks via operating-system shell scripts. Monitor, tune, and optimize Linux and Solaris servers for Oracle. Setup a VirtualBox environment for the Oracle database. Perform system administration tasks relevant to Oracle Database. Remotely (and securely!) manage Oracle on Linux and Solaris. Who This Book Is For Linux and Solaris Recipes for Oracle DBAs is a book for Oracle database administrators who want to expertly operate Oracle databases on the Linux and Solaris operating systems. If you're new to Linux and Solaris and can benefit from detailed examples showing how to perform tasks that Oracle DBAs perform on Linux and Solaris servers, then this book is what you need to help you get the job done, and get home on time.

Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. APEX has seen meteoric growth and is becoming the tool of choice for ad-hoc application development in the enterprise. The many authors of Expert Oracle Application Express, 2nd Edition build their careers around APEX. They know what it takes to make the product sing-developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding globalization, configuration and lifecycle management, and more. New in this edition for APEX 5.0 is coverage of Oracle REST Data Services, map integration, jQuery with APEX, and the new Page Designer. You'll learn about debugging and performance, deep secrets to customizing your application u ser interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express, 2nd Edition is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Contains all-new content on Oracle REST Data Services, jQuery in APEX, and map integration Addresses globalization and other concerns of enterprise-level development Shows how to customize APEX for your own application needs