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 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.
|
|
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) |
|
New SQL Capabilities in Oracle Database 10g (PDF) |
|
SQL 2003 Standard Support in Oracle Database 10g (PDF) |
|
Oracle Database 10g: Handling Application Events with Rules Manager (PDF) |
|
Oracle Database 10g Expression Filter Overview (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
