Oracle Database Online Documentation 12c Release 1 (12.1)
Application Development
Application development for Oracle Database involves a wide range of programming technologies. The supporting documentation covers the languages, programming interfaces, and development tools in detail.Essentials
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.
Introduces you to application development using Oracle Application Express. This manual shows you how to set up a development environment, or access a hosted demonstration environment. It then walks you through building an initial application, modifying it, and previewing it.
Guides application developers on how to use Java to access and modify data in Oracle Database.
Download As...
PDF for offline viewing
Provides a tutorial on how to develop PHP scripts that use the database languages SQL and PL/SQL to access and manipulate Oracle data.
Download As...
PDF for offline viewing
Application Development Concepts
These guides provide advanced conceptual and architectural information applicable to all development environments and languages with which you can develop Oracle applications.Describes use of SecureFiles and large object data types BLOB, CLOB, NCLOB, and BFILE in application development. Presents APIs for working with LOBs in supported programmatic environments. Describes database file systems and the Oracle Database File System Hierarchical Store package.
Download As...
PDF for offline viewing
Describes 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.
SQL and PL/SQL
SQL and PL/SQL are fundamental to all Oracle application development. SQL is the language used to query and modify Oracle databases. PL/SQL is used to create and call triggers, stored procedures and functions, and PL/SQL packages. Other programming technologies depend upon SQL and PL/SQL to interact with the Oracle Database server.SQL Developer and SQL Plus
Oracle SQL Developer is a powerful easy-to-use GUI with browse, create, edit, and drag-and-drop capabilities for managing database objects, and creating and viewing reports. SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer has all the capabilities of SQL*Plus in a GUI-based interface.Provides conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; migrate third-party databases to Oracle; view metadata and data in third-party databases; and view and create reports.Note: This book is for an old release of SQL Developer. You are encouraged to use the latest available release. See http://www.oracle.com/technetwork/developer-tools/sql-developer/ for information about downloads and documentation.
Provides introductory, installation, post-installation configuration, and usage information for Oracle Database Extensions for .NET, which makes it possible to build and run .NET stored procedures or functions with Oracle Database for Microsoft Windows.
Application Express
Oracle Application Express is a declarative, rapid web application development tool for the Oracle database. It is a fully supported, no cost option available with all editions of the Oracle database. Using only a web browser, you can develop and deploy professional applications that are both fast and secure.Introduces you to application development using Oracle Application Express. This manual shows you how to set up a development environment, or access a hosted demonstration environment. It then walks you through building an initial application, modifying it, and previewing it.
Java
The Java programming language is used for database code that runs inside the database, on a middle tier, or on a client system. Reference documentation for database components that have Java APIs is presented in Javadoc format.Guides application developers on how to use Java to access and modify data in Oracle Database.
Download As...
PDF for offline viewing
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 Java API reference for Java Database connectivity.
Download As...
Provides reference information for the Oracle OLAP Java API.
Download As...
Describes APIs for the Oracle Globalization Development Kit.
Download As...
Provides Java API reference for Universal Connection Pool for JDBC.
Download As...
Provides easy access to Oracle Fast Application Notification (FAN) events.
Download As...
Describes Java APIs for XML.
Download As...
Provides Javadoc-generated information about interfaces and classes that support features available with Oracle Spatial and Graph, including GeoRaster and the Topology Data Model and Network Data Model Graph features, and with MapViewer, which is packaged with Oracle Fusion Middleware.
Download As...
Presents reference information about writing Java applications using Oracle Multimedia objects to manage multimedia content within Oracle Database.
Download As...
Presents reference information about writing Java applications using the Oracle Multimedia object designed to store Digital Imaging and Communications in Medicine (DICOM) data within Oracle Database.
Download As...
Presents reference information about writing Java applications using Oracle Multimedia to extract Digital Imaging and Communications in Medicine (DICOM) metadata outside of the database, either on the client or in the middle tier.
Download As...
Presents reference information about writing Java applications using Java servlets and JavaServer Pages (JSP) to retrieve and upload multimedia data from and to Oracle Database.
Download As...
.NET and Windows Application Development
The topics below are also available in a rich context-sensitive help set installed in the Visual Studio environment when you install Oracle Developer Tools for Visual Studio (ODT). This help set includes documentation for ODT, Oracle Data Provider for .NET, PL/SQL and SQL language reference guides, and other reference topics.Provides introductory, installation, post-installation configuration, and usage information for Oracle Database Extensions for .NET, which makes it possible to build and run .NET stored procedures or functions with Oracle Database for Microsoft Windows.
Describes Oracle Services for Microsoft Transaction Server, which allows Oracle databases to be used as resource managers in distributed transactions. The guide describes its usage and configuration in a Microsoft Distributed Transaction Coordinator environment.
XML
Oracle XML DB and XML Developer's Kit enable you to develop high performance applications that process XML content and manage XML stored in the database. XDK and XML APIs allow you to generate and store XML data in the database or in documents outside the database.Describes Java APIs for XML.
Download As...
Globalization Support
You can store data from different character sets and code pages, and manipulate and present that data as appropriate for each locale.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 APIs for the Oracle Globalization Development Kit.
Download As...
Introduces you to the Oracle Database Migration Assistant for Unicode, discusses the database character set migration process, and verifies that there are no character set data problems in a current Unicode database.
Oracle Call Interface
The Oracle Call Interface is for low-level, efficient coding in C or C++.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).
Precompilers
The precompilers are used for traditional client-server applications in various languages.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.
Contains important information not included in the Pro*COBOL Programmer's Guide.
Download As...
PDF for offline viewing