United StatesChange Country, Oracle Worldwide Web Sites Communities I am a... I want to...

Oracle Database Application Development

Oracle Database 11g is a single integrated platform that supports SQL, XML, and procedural languages (e.g., PL/SQL, Java, C/C++) in a simple fashion with high performance and scalability. The information below describes many of the features of the Oracle database that facilitate Database Application Development. This includes languages, tools, connectivity and technologies that are supported.
 

Languages
SQL/XML
Oracle Database 11g supports SQL/XML standard features, which are new in the SQL 2003 standard as Part 14. The SQL/XML standard defines how SQL can be used in conjunction with XML in a database, including detailed definition of a new XML type, the values of an XML type, mappings between SQL constructs and XML constructs, and functions for generating XML from SQL data.
PL/SQL
PL/SQL is an imperative 3GL that was designed specifically for the seamless processing of SQL commands. It provides specific syntax for this purpose and supports exactly the same datatypes as SQL. Server-side PL/SQL is stored and compiled in Oracle Database and runs within the Oracle executable. It automatically inherits the robustness, security, and portability of Oracle Database.
.NET
Oracle provides significant support and products for developers using Visual Studio .NET and .NET Web Services, who need to develop enterprise applications.
Java in the Database
Java, JDBC and Web Services features bring productivity, security, scalability, reliability, performance, integration of existing software assets, connectivity to Grid-enabled database, support for non-connected clients through Web Services, the federation of local data with remote and dynamic data.
C
Oracle Call Interface (OCI) is the most comprehensive, high performance, native C language-based interface that exposes the Oracle Database's full power.
C++
Based on standard C++, Oracle C++ Call Interface (OCCI) is a high-performance and comprehensive API to access the Oracle Database.
XML DB
Oracle XML DB provides a high-performance, native XML storage and retrieval technology. It fully absorbs the W3C XML data model into the Oracle Database, and provides new standard access methods for navigating and querying XML.
PHP
The PHP revolution has finally hit the enterprise: PHP is making an impact on large enterprise developments, and use of this open-source scripting language is expanding to new horizons.
Scripting Language Technology Center
Technical information about the use of open-source scripting languages like Ruby and Python in conjunction with enterprise-class Oracle technology.

Tools
SQL Developer
Oracle SQL Developer is a free and supported graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements.
SQL Developer Data Modeler
Oracle SQL Developer Data Modeler is an independent, standalone product with a full spectrum of data and database modeling tools and utilities.
Oracle Application Express
Oracle Application Express (Oracle APEX), formerly called HTML DB, is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure.
Oracle Developer Tools for Visual Studio
The Oracle Developer Tools for Visual Studio (ODT) is a tightly integrated "Add-in" for Microsoft Visual Studio. ODT is free and supports the latest versions of Visual Studio.
Migration Technologies
Resources to find out about the tools, services, and partners that are available to help with the migration of your databases and applications to the Oracle platform.
   

Connectivity
Instant Client
Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.
JDBC
In addition to supporting the standard JDBC 4.0 APIs, Oracle drivers have extensions to support Oracle-specific data types, enhance performance, and expose generic database capabilities aiming at improving Java application development. Features available through JDBC include: SYS.ANYDATA and SYS.ANYTYPE data types, LOB prefetching, SecureFiles LOBs, Client & Server Query Result cache, and query change notification.
Oracle Data Provider for .NET
The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to the Oracle database. ODP.NET allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security.
Oracle Call Interface (OCI)
OCI provides the most comprehensive access to all of the Oracle Database functionality. The newest performance, scalability, and security features appear first in the OCI API.
Oracle C++ Call Interface (OCCI)
OCCI is a high-performance and comprehensive API to access the Oracle Database. Based on Standard C++ and object-oriented paradigm, OCCI is designed for improved productivity and quality in developing Oracle database applications.
Oracle Net Services
Oracle Net Services provides enterprise wide connectivity solutions in distributed, heterogeneous computing environments. Additionally, it eases the complexities of network configuration and management, maximizes performance, and improves network security and diagnostic capabilities.
Precompilers
Oracle 11g includes Pro*C/C++, Pro*COBOL, Pro*FORTRAN, and Pro*PL/1.
XML Developer's Kit (XDK)
Oracle XML Developer's Kit 10g is a set of components, tools and utilities in Java, C, and C++ which is available in Oracle Database 10g, Oracle Application Server 10g and on OTN that eases the task of building and deploying XML-enabled applications with a commercial redistribution license.

Technologies
Globalization
Globalization Support allows customers to run Oracle products throughout the world simultaneously while presenting content in the users' native language and locale preferences. Perhaps more importantly, Globalization Support enables customers to develop their own multilingual applications and software products using the Oracle technology stack including the Globalization Development Kit (GDK).
Extensibility Framework
Oracle Database 11g Extensibility Framework provides unprecedented capabilities to efficiently store, retrieve, query, and process specialized data types (e.g., spatial, multimedia, bioinformatics data). Many of these data types are well beyond the reach of traditional databases.
Database Web Services
The Oracle Database can function in two different modes to support Web services development and deployment: Database as Web Services Provider or Database as Web Services Consumer. As a Web Services Provider, database operations and data retrieval are executed through Web Services mechanisms. In conjunction with Oracle Application Server Web Services Framework, Oracle Database allows instant interoperability and consistent Web services development and deployment. As a Web Services Consumer, external Web Services are included as part of a SQL query or database batch processing.

Other
Rules Manager & Expression Filter
Workspace Manager
 
Technical Collateral
Oracle Database 11g Release 2 Application Development (PDF)
Identity Code Package - Support for RFID and EPC in Oracle Database 11g, a feature overview (PDF)
New SQL Capabilities in Oracle Database 10g (PDF)
SQL 2003 Standard Support in Oracle Database 10g (PDF)
Introducing Oracle Regular Expressions (PDF)
 
Left Curve
Popular Downloads
 Right Curve
Untitled Document
Left Curve
More Database Downloads
 Right Curve