Oracle® Database Express Edition Application Express User's Guide Release 2.1 Part Number B25309-01 |
|
|
View PDF |
Oracle Database Express Edition Application Express User's Guide describes how to use the Oracle Application Express client within Oracle Database Express Edition (Oracle Database XE).
This preface contains these topics:
This document contains the following chapters:
Title | Description |
---|---|
Quick Start |
Offers a quick introduction to using the Oracle Application Express client within Oracle Database XE. |
Running a Demonstration Application |
Describes how to run and modify the demonstration applications that install with Application Builder. |
Application Builder Concepts |
Provides basic conceptual information about Application Builder. Use Application Builder to assemble an HTML interface (or application) on top of database objects such as tables and procedures. |
Using Application Builder |
Provides important background information about using Application Builder to build dynamically rendered applications. |
Building an Application |
Describes how to use Application Builder to build an application and application components. |
Controlling Page Layout and User Interface |
Describes different approaches to customizing an application's user interface and page layout including customizing regions, editing item attributes, customizing templates, and incorporating cascading style sheets and images. |
Adding Navigation |
Describes how to implement navigation in your application using different types of navigation controls, including navigation bar entries, tabs, breadcrumbs, lists, and trees. |
Understanding Application Administration |
Explains how to mange your application development environment, including managing application services, session state, user preferences, log files, application models, Application Express end users, application development activity, and explains how to send email from an application. |
Managing User Interface Defaults |
Describes how to use user interface defaults to assign default user interface properties to a table, column, or view. |
Debugging an Application |
Describes approaches to debugging your Application Builder application, including viewing Debug Mode, enabling SQL tracing, viewing page reports, and how to manually remove a control or a component to isolate a problem. |
Deploying an Application |
Explains how to deploy an application built within Application Builder. |
Managing Application Security |
Describes how to provide security for an Application Builder application by utilizing cross-site scripting protection, session state protection, authentication, and authorization. |
Advanced Programming Techniques |
Provides information about advanced programming techniques including establishing database links, using collections, running background SQL, utilizing Web services, and managing user preferences. |
Managing Application Globalization |
Explains how to translate an application built-in Application Builder. |
Oracle Application Express APIs |
Describes the APIs available in Oracle Application Express. |
Managing Database Objects with Object Browser |
Describes how to use Object Browser to browse, create, and edit objects in an Oracle Database Express Edition database. |
Building Queries with Query Builder |
Explains how to use Query Builder's graphical user interface to search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save queries. |
Using SQL Scripts |
Provides information on how to use SQL Scripts to create, edit, view, run, and delete script files. |
Using SQL Commands |
Explains on how to use SQL Commands to create, edit, view, run, and delete SQL commands. |
Using SQL Utilities |
Describes how to use SQL Utilities to load and unload data from the Oracle Database XE database, generate DDL, view object reports, and restore dropped database objects. |
Administering the Database |
Describes how to administer the Oracle Database XE database. |
Oracle Database Express Edition Application Express User's Guide is intended for application developers who are building database-centric Web applications using the Oracle Application Express client within Oracle Database XE. Oracle Database XE includes an intuitive browser-based user interface. This browser-based user interface is built within the Oracle Application Express client. The guide describes how to use the Oracle Database XE browser-based user interface to administer the database, run scripts and queries, and build Web-based application.
To use this guide, you need to have a general understanding of relational database concepts as well as an understanding of the operating system environment under which you are running the Oracle Database XE.
See Also:
"Introducing Oracle Database XE" in Oracle Database Express Edition 2 Day DBA GuideOur goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
http://www.oracle.com/accessibility/
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
For more information, see these Oracle resources:
Oracle Database Express Edition Installation Guide for Linux
Oracle Database Express Edition Installation Guide for Microsoft Windows
Oracle Database Express Edition 2 Day Plus Application Express Developer Guide
For the most recent version of the Oracle Database Express Edition documentation, see the Oracle Database XE online library:
http://www.oracle.com/technology/xe/documentation
The following text conventions are used in this document:
Convention | Meaning |
---|---|
boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. |
italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. |
monospace |
Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. |