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 Oracle's procedural extension
to industry-standard SQL. PL/SQL naturally, efficiently, and
safely extends SQL. Its primary strength is in providing a
server-side, stored procedural language that is easy-to-use,
seamless with SQL, robust, portable, and secure. |
 |
.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. |
 |
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. |
 |
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. |
 |
SQL*Plus
SQL*Plus, the primary interface to
the Oracle Database server, provides a powerful yet easy-to-use
environment for querying, defining, and controlling data.
SQL*Plus delivers a full implementation of Oracle SQL and
PL/SQL, along with a rich set of extensions. |
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. |
 |
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
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) |
| |
| Technical Articles
|
 |
Building Applications in the Cloud - Combine Oracle Application Express and Amazon EC2. Sep 2009 |
 |
Choosing the Right Tool - Evaluate your organization's needs against Oracle tool releases. Jul 2009 |
 |
Developing Secure Applications - Defend your Oracle Application Express applications against unauthorized use. Jul 2009 |
 |
United Development - Bring together the languages and technologies your applications demand with Oracle development solutions. May 2009 |
 |
Creating Custom Authentication - Build single sign-on/sign-off for a suite of applications in Oracle Application Express. May 2009 |
 |
Converting Forms - Modernize Oracle Forms applications with Oracle Application Express. May 2009 |
 |
Improving Application Performance - Manage and tune Oracle Application Express applications with Oracle SQL Developer Mar 2009 |
 |
Programming Productively - Use Oracle SQL Developer to work efficiently with PL/SQL constructs. Nov 2008 |
 |
Document, Monitor, and Manage - Take advantage of new features in Oracle SQL Developer 1.5. Sep 2008 |
 |
Managing File Versions - Edit files and use version control in Oracle SQL Developer 1.5. Jul 2008 |