Oracle Database Online Documentation 11g Release 2 (11.2)

Application Development

Application development for Oracle Database involves a wide range of programming technologies. The 2 Day + books walk through the process of creating a basic application in various programming languages. The supporting documentation covers the languages, programming interfaces, and development tools in detail.

Essentials

The 2 Day Developer's Guide covers recommended practices for server-side development with SQL and PL/SQL. The 2 Day + books in this list cover application development in the given environment.

Explains general concepts behind development with Oracle Database, introduces basic features of SQL and PL/SQL, and provides references to in-depth information elsewhere in the Oracle Database library.

Serves as a quick start guide, which describes Oracle technologies for the Microsoft .NET Framework, including the key features of Oracle Data Provider for .NET and Oracle Developer Tools for Visual Studio. It leads you through installation and configuration, shows how to build basic applications using Oracle .NET products, and how to create and use both PL/SQL and .NET stored procedures.

Describes use of large object data types BLOB, CLOB, NCLOB, and BFILE in application development. Presents APIs for working with LOBs in supported programmatic environments, and SecureFiles, that are LOBs that support compression, encryption, and deduplication. Describes database file systems and the Oracle Database File System Hierarchical Store package.

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.

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.

Describes the sample schemas included in the seed database that ships with Oracle Database 11g. These schemas are used in examples in Oracle documentation, in curriculum materials, and in demos on Oracle Technology Network.

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.

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.

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 Javadoc-generated information about interfaces and classes that support features available with Oracle Spatial, including GeoRaster and the topology and network data models, and with MapViewer, which is packaged with Oracle Fusion Middleware.

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. (Oracle Multimedia was formerly known as Oracle interMedia.)

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. (Oracle Multimedia was formerly known as Oracle interMedia.)

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. (Oracle Multimedia was formerly known as Oracle interMedia.)

Download As...

.NET and Windows Application Development

The 2 Day + .NET Developer's Guide is for Visual Studio users getting started with Oracle Data Access Components for .NET. 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.

Serves as a quick start guide, which describes Oracle technologies for the Microsoft .NET Framework, including the key features of Oracle Data Provider for .NET and Oracle Developer Tools for Visual Studio. It leads you through installation and configuration, shows how to build basic applications using Oracle .NET products, and how to create and use both PL/SQL and .NET stored procedures.

ODP.NET support for Oracle TimesTen In-Memory Database (TimesTen) enables ADO.NET data access from .NET client applications to TimesTen databases. This document covers features specific to ODP.NET support of and use with TimesTen.

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.

Describes Oracle Objects for OLE (OO4O), a COM-based data access driver that combines seamless and optimized access to Oracle databases with easy to use interfaces, and shows how to use and configure OO4O from virtually any Microsoft COM Automation programming or scripting language, such as Visual Basic.

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. Examples and sample applications are introduced. Developers need familiarity with XML and a third-generation programming language such as Java, C, or C++.

Globalization Support

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.

Oracle Call Interface

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). Support for these tags has been added in this release.

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.