Oracle Database 19c

Guides application developers on how to use Java to access and modify data in Oracle Database.

Provides a single source reference for administering Oracle Database in a small to midsize environment, using the graphical user interface of Oracle Enterprise Manager Database Express. If you are familiar with computers, but unfamiliar with administering Oracle Database, and your computer has four CPUs or fewer, and you do not expect to support more than 500 users, this book is appropriate for you.

An introduction to application development for developers who are new to Oracle Database. Explains general concepts behind development with Oracle Database, introduces basic features of SQL and PL/SQL, provides references to in-depth information elsewhere in Oracle Database library, and shows how to create a simple application.

Explains how to configure and manage Oracle Database on Linux and UNIX-based operating systems.

Explains how to configure and use Oracle Database Advanced Security Transparent Data Encryption (TDE) and Oracle Data Redaction.

Describes how to administer Oracle Automatic Storage Management (Oracle ASM) and Oracle Automatic Storage Management Cluster File System (Oracle ACFS) for Oracle Database.

This book describes how to use Oracle Autonomous Health Framework diagnostic components - Oracle ORAchk, Cluster Health Monitor, Oracle Trace File Analyzer Collector, Oracle Cluster Health Advisor, Memory Guard, and Hang Manager.

The Oracle Clusterware Administration and Deployment Guide describes the Oracle Clusterware architecture and provides an overview of this product. This book also describes administrative and deployment topics for Oracle Clusterware.

Describes how to implement custom indexing and query optimization services and how to package and use these as a server extension called a data cartridge.

Describes the Oracle Data Guard broker, a management and monitoring interface that automates many of the tasks involved in configuring and monitoring standby databases in an Oracle Data Guard configuration.

Provides a comprehensive overview of Oracle Data Guard concepts and describes how to configure and implement standby databases that can take over production operations if your production database becomes unusable. This guide includes several database scenarios such as creating, recovering, failing over, switching over, configuring, and backing up standby and primary databases.

Provides reference information on Oracle Data Mining - Introduction, Using API, Data Mining API reference

Discusses the basic concepts underlying Oracle Data Mining. Includes an overview of the features of Oracle Data Mining and information about mining functions and algorithms.

Explains how to use the SQL interface to Oracle Data Mining to create models and score data. This Guide also addresses administrative issues such as security, import/export, and upgrade for Oracle Data Mining.

Explains how to perform day-to-day database performance tuning tasks using features provided by Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Enterprise Manager Cloud Control.

Describes how to create, configure, and administer an Oracle database. Includes sections on Oracle Scheduler, Oracle Database Resource Manager, Oracle Restart, and distributed computing.

Provides detailed descriptions of the Recovery Manager (RMAN) commands and recovery catalog views.

Explains how to use Recovery Manager (RMAN) to back up, recover, and duplicate a database, and how to use Oracle Flashback Technology to restore all or a portion of your data to a previous state.

Describes how to install and configure Oracle Database client on Linux.

Describes how to install and configure Oracle Database Client on Oracle Solaris.

Describes Oracle Database architecture and essential topics for database administrators and developers.

Provides conceptual, reference, and implementation material for using Oracle Database in data warehousing. It covers the full range of data warehousing activities, from physical database design to advanced calculation techniques.

Describes various features that are available in the Oracle database and how to use them in real time applications.

Describes error messages that may appear while using products that are part of Oracle Database.

Describes how to install and configure the products available on the Oracle Database Examples installation media.

Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing.

Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing.

Provides Oracle applications seamless access to virtually any APPC-enabled system, including IBM mainframe data and services through Remote Procedure Call (RPC) processing.

Provides users with transparent access to DB2.

Describes the Oracle Database Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language (SQL).

Describes the Oracle Database Gateway for ODBC, which enables Oracle client applications to access non-Oracle systems data through Structured Query Language (SQL).

Describes the Oracle Database Gateway for SQL Server, which enables Oracle client applications to access SQL Server data through Structured Query Language (SQL).

Describes the Oracle Database Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language (SQL).

Describes the Oracle Database Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language (SQL).

Provides access to WebSphere MQ services. This gateway requires a system that is capable of running 64-bit applications.

Provides Oracle Database Gateway installation and configuration information.

Describes how to install Oracle Database Gateway for Sybase, Informix, Teradata, SQL Server, ODBC, and DRDA on Microsoft Windows (32-bit) and Microsoft Windows (64-bit) platform.

Describes Java APIs for Oracle Database Globalization Development Kit (GDK).

Describes Oracle globalization support for the database. Explains how to set up a globalization support environment, choose and migrate a character set, customize locale data, do linguistic sorting, program in a global environment, and program with Unicode.

Describes the architecture, configuration, and administration of the In-Memory Column Store

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database and Oracle Grid Infrastructure for a standalone server on Linux.

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Database, and Oracle Grid Infrastructure for a standalone server on Oracle Solaris.

Describes Oracle Database licensing. If you have a question about your licensing needs, contact your Oracle sales representative.

Contains complete listing with descriptions of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.

Oracle Database New Features Guide is addressed to those of you who would like to become familiar with features, options, and enhancements that are new in this release of the database.

Provides information about how to tune the performance of Oracle Database using Oracle performance tools.

Presents PL/SQL, the Oracle procedural extension of SQL, an advanced fourth-generation programming language. Explains the concepts behind PL/SQL and illustrates every facet of the language.

Describes the PL/SQL packages provided with the Oracle database server that extend database functionality and provide PL/SQL access to SQL features.

Provides reference information about database initialization parameters, static data dictionary views, and dynamic performance views that are part of Oracle Database.

Contains information about new features, changes, unsupported products, preinstallation requirements, generic and platform-specific bug fixes, and known issues that are not included in the Oracle Database Documentation Library.

Sample schemas provide a common platform for examples in each release of the Oracle Database. The sample schemas are a set of interlinked database schemas.

Explains how to configure an Oracle database to use the default security features

Guides you through the process of planning and performing upgrades for Oracle Database. This book also provides information about compatibility, upgrading applications, and changes in the new release that affect upgrading Oracle Database.

Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. The topics discussed include Data Pump Export, Data Pump Import, SQL*Loader, external tables and associated access drivers, the Automatic Diagnostic Repository Command Interpreter (ADRCI), DBVERIFY, DBNEWID, LogMiner, the Metadata API, original Export, and original Import.

Describes how to register and administer Oracle Database Vault

Provides deployment scenarios for using Rapid Home Provisioning for installation, upgrades, and patching.

Provides dynamic load balancing, failover, and centralized service management for a set of replicated databases that offer common services.

Describes how to install and upgrade grid infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Linux.

Describes how to install and upgrade Oracle Grid Infrastructure for a cluster software, which includes Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM), on systems running Oracle Solaris.

Describes Oracle's approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is a user's guide for these Oracle products.

Describes how to develop, load, and run Java applications in Oracle Database.

Describes how to use Oracle JDBC drivers to develop powerful Java database applications.

This manual describes the use of JSON data that is stored in Oracle Database. It covers how to store, generate, view, manipulate, manage, search, and index it.

Describes how to register and administer Oracle Label Security

Guides you through the scenario in which you upgrade and convert a non-CDB Oracle Database to multitenant architecture database (pluggable database, or PDB, plugged into a container database, or CDB), which is located on an operating system that uses a different Endian format from your earlier release Oracle Database.

Guides you through the scenario in which you migrate your Oracle Database to a new server with an operating system that uses a different Endian format, and you upgrade your database.

Guides you through the scenario in which you migrate your non-CDB Oracle Database to a new server with an operating system that uses a different Endian format, where you maintain the same Oracle Database release.

Guides you through the scenario in which you migrate your Oracle Database to a new server with the same operating system, and you upgrade your database.

Guides you through the scenario in which you migrate your non-CDB Oracle Database to a new server with the same operating system, and maintan the same Oracle Database release.

Describes how to create, configure, and administer a multitenant container database (CDB). Includes sections on creating CDBs, pluggable databases (PDBs), and application containers. Also contains sections on administering CDBs, PDBs, and application containers.

Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.

Explains how to use the object-relational features of Oracle Database.

Describes Oracle Database ODBC driver new features, functionality, platforms supported, software required, server requirements, hardware required, testing matrix, UNIX platform certification matrix, post-installation, known issues, and software problems fixed.

Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.

Describes the Oracle OLAP expression syntax used to generate information-rich content from the data stored in dimensional database objects such as cubes and cube dimensions.

Provides guidance for developing client applications using the Oracle OLAP Java API.

Explains how SQL applications can extend their analytic processing capabilities and manage summary data by using the OLAP option of Oracle Database.

Presents the Oracle C++ Call Interface, an application program interface that enables applications written in C++ to interact with one or more Oracle databases. To extend the functionality of code generated by the Object Type Translator, programmers may want to add code in the OTT-generated file. The OTT can distinguish between OTT-generated code and user-generated code by looking for some predefined markers (tags).

Describes the Oracle Call Interface (OCI) which is an application programming interface (API) that allows applications written in C or C++ to interact with Oracle Database.

Provides reference information for the Oracle OLAP Java API.

Provides Javadoc-generated information about interfaces and classes that support features available with Oracle Spatial and Graph, including GeoRaster, the Topology Data Model and Network Data Model Graph features, the location tracking server, and the map visualization component (formerly called MapViewer).

Describes features of application development and integration using Oracle Database Advanced Queuing (AQ). This information applies to versions of the Oracle Database server that run on all platforms, unless otherwise specified.

Describes the Java APIs for application development and integration using the Oracle messaging system, Advanced Queuing.

Provides Java API reference for Java Database connectivity.

Provides easy access to Oracle Fast Application Notification (FAN) events.

Documents two Java packages: - oracle.security.xs contains the APIs for using lightweight user sessions - oracle.security.xs.admin contains the APIs for administering lightweight user session.

Documents one Java package: - oracle.security.xs.ee.session contains the APIs for using an application session service.

Describes Java APIs for XML.

Describes the Java APIs for XStream.

Provides Java API reference for Universal Connection Pool for JDBC.

Describes how to develop C++ programs that use the SQL and PL/SQL database languages to access and manipulate Oracle data.

Contains important information not included in the Pro*C/C++ Programmer's Guide.

Describes how to develop COBOL programs that use the database languages SQL and PL/SQL to access and manipulate Oracle data.

Contains important information not included in the Pro*COBOL Programmer's Guide.

Supplements the Oracle Database Programmer's Guide to the Oracle precompilers to provide additional information on how to develop FORTRAN programs that use the database languages SQL and PL/SQL to access and manipulate Oracle data.

Describes how to develop applications using the Oracle precompilers and the SQL and PL/SQL database languages to access and manipulate Oracle data.

For customers who have a large investment in DB2-based applications, this document describes how to migrate to Oracle Database while keeping these applications largely unchanged.

Describes the Oracle Real Application Clusters (Oracle RAC) architecture and provides an overview of this product, including Oracle Real Application Clusters One Node (Oracle RAC One Node).

Describes how to install and configure Oracle Real Application Clusters (Oracle RAC) on systems running Linux and UNIX.

Provides a graphical user interface (RASADM) that security administrators and developers using Real Application Security can use to develop end-to-end security for mid-tier applications. The RASADM application allows users to develop declarative data security policies to enforce access control requirements at the database layer to protect data at both the row and column levels. This approach allows developers to control application user access to data in Oracle database throughout all components of an Oracle enterprise in a common manner.

Describes how to implement Real Application Security on the database. Real Application Security is a new feature in Oracle Database 12c. Real Application Security is a database authorization model that enables end-to-end security for multitier applications. It provides an integrated solution to securing the database and application user communities. Also, it advances the security architecture of Oracle Database to meet existing and emerging demands of applications developed for the Internet.

Provide consumers the ability to perform operations with different Oracle Database features through a web REST API that can be easily adopted.

This guide explains what are Large Objects(LOBs), different types of LOBs, their usage and utilities, configuring LOBs, and how to use the LOBs in real time applictions

Provides usage and reference information for indexing and storing spatial data and for developing spatial applications using Oracle Spatial and Graph and Oracle Locator.

Provides usage and reference information for the GeoRaster feature of Oracle Spatial and Graph, which lets you store, index, query, analyze, and deliver raster data (raster image and gridded data and its associated metadata).

Provides Javadoc-generated information about interfaces and classes that support the in-memory analyst feature of Oracle Spatial and Graph, which provides a set of analytical functions.

Provides JSdoc-generated reference information for the Oracle Spatial and Graph Map Visualization Component (formerly called MapViewer) Oracle Maps HTML5 JavaScript API.

Describes how to use the Oracle Spatial and Graph map visualization component, which renders maps showing different kinds of spatial data. It is intended primarily for programmers who develop applications that require maps to be drawn.

Provides usage and reference information for the property graph support in Oracle Spatial and Graph.

Provides Javadoc-generated information about interfaces and classes that support property graph features available with Oracle Spatial and Graph.

Provides usage and reference information about Oracle Database support for semantic technologies, including storage, inference, and query capabilities for data and ontologies based on Resource Description Framework (RDF), RDF Schema (RDFS), and Web Ontology Language (OWL).

Provides usage and reference information about the Topology Data Model and Network Data Model Graph features of Oracle Spatial and Graph.

Contains a high-level text description of the SQL syntax used to manage information in Oracle Database.

Contains a complete description of Oracle SQL, the language used to manage information in Oracle Database.

Describes the installation, configuration, and administration tasks for all activities related to migrating applications to Oracle Database from other databases, including DB2, MySQL, and Sybase.

Describes how to perform SQL tuning, which is the iterative process of improving SQL statement performance to meet specific, measurable, and achievable goals.

Contains a complete list of SQL*Plus command syntax.

Contains important information not included in the SQL*Plus User's Guide and Reference.

Contains a complete description of the SQL*Plus command-line interface to Oracle Database, and a complete reference to SQL*Plus commands and syntax.

Provides guidance to developers on SQLJ programming. This document can be read by anyone with an interest in SQLJ programming, but assumes at least some prior knowledge of Java, SQLJ, PL/SQL, and Oracle database.

Provides information about how to assure the integrity of database changes and manage test data using Oracle Real Application Testing.

Provides information for building applications with Oracle Text.

Provides reference information for building applications with Oracle Text.

Provides instructions for using Oracle Universal Connection Pooling API.

Guides you through the scenario in which you upgrade your multitenant architecture Oracle Database (pluggable database, or PDB, plugged into a container database, or CDB) by using the unplug/plugin method.

Guides you through the scenario in which you upgrade and convert your earlier release non-CDB Oracle Database to a multitenant architecture Oracle Database (pluggable database, or PDB, plugged into a container database, or CDB), where the upgraded Oracle Database is on the sam eoperating system as your earlier release Oracle Database.

Guides you through the scenario in which you upgrade a non-CDB Oracle Database on the same system.

Guides you through the scenario in which you upgrade a multitenant architecture Oracle Database (container database, or CDB, and all pluggable databases, or PDBs) on the same system.

Create, deploy, and manage a sharded database using Oracle Sharding

Contains an overview of very large database (VLDB) topics, with emphasis on partitioning and parallel execution as a key component of the VLDB strategy.

Provides usage and reference information about Oracle Workspace Manager, which enables applications to create workspaces and to group different versions of table row values in different workspaces.

Describes Oracle XML Developer's Kit (XDK) and Oracle XML DB APIs for the C programming language. It primarily lists the syntax of functions, methods, and procedures associated with these APIs.

Describes Oracle XML Developer's Kit (XDK) and Oracle XML DB APIs for the C++ programming language. This manual primarily lists the syntax of functions, methods, and procedures associated with these APIs.

This manual describes Oracle XML DB. It includes guidelines and examples for storing, generating, accessing, searching, validating, transforming, evolving, and indexing XML data in Oracle Database.

Provides information to application developers who need to use components of the Oracle XML Developer's Kit (XDK) to generate and store XML data in a database or in a document outside the database.

Contains conceptual information about XStream. Also contains instructions for configuring and using XStream.