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 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 |
>
|
Express
Web 2.0 - Create dynamic interfaces that minimize page refresh
with Oracle Application Express Sep
2007 |
|
A
Practical Demonstration of SaaS using Oracle Application Express
Aug 2007 |
|
Extending
Oracle SQL Developer - Build extensions for Oracle SQL Developer
with SQL and XML July 2007 |
|
Now
Reporting - Build chart, drill-down, and master/detail reports
with Oracle SQL Developer May 2007 |
|
Jonathan
Gennick on Regular Expressions in Oracle Database 10g
Sep 2003 |
|
Steven
Feuerstein on Multiset Operations in Oracle Database 10g
Sep 2003 |
|
Jonathan
Gennick on SQL/XML Standard Functions in Oracle Database 9i
Release 2 May 2003 |
Bookmark
