PacktLib: Oracle Application Express 3.2 - The Essentials and More

Oracle Application Express 3.2

Credits

About the Authors

About the Reviewers

Preface

An Introduction to APEX

Web-based

Native Web based

Data Centric

A declarative development tool

RAD tool

Globalization, localization, and NLS

APEX architecture

Summary

What we need to know to effectively use APEX

SQL and PL/SQL

HTML and CSS

JavaScript

HTML

CSS

JavaScript

Summary

APEX Basic Concepts

Session state

Substitution strings

Shortcuts

Themes and templates

The f?p URL notation

APEX multi-lingual support

Summary

The Application Builder Basic Concepts and Building Blocks

The APEX Workspace

Start working with APEX

The APEX IDE home page

The APEX Application Builder

The Page component

Summary

APEX Items

Naming conventions and rules

Application items

Page items

APEX pre-defined item types

Summary

APEX Buttons

Button styles

Button positioning

Create new button(s)

Edit a button

The REQUEST feature

Using JavaScript with "among this region's items" buttons

Re-visit the Buttons section

Summary

APEX Computations

Create a page level computation

Create an application level computation

Edit computations

Computations and Session State

Summary

APEX Validations

Data validation

How APEX validation works?

Creating a new validation

Edit validations

Client-side validation

Summary

APEX Processes

Application Processes

Page level processes

On Demand processes

Summary

APEX Branches

Application flow

Creating a new branch

Edit branch

Other ways to control the application flow

Summary

APEX SQL Workshop

Navigating around the SQL workshop

Object Browser

SQL Commands

SQL Scripts

Query Builder

Summary

APEX Forms

Sources for creating a form

Creating a new form

A new form has been created

Manually creating an APEX form

Summary

APEX Reports

Report regions

Creating a simple report using a wizard

Modifying a report manually

Charts

Summary

Tabular Forms

What is a Tabular Form?

Using a wizard to create a Tabular Form

Manually building a Tabular Form

Summary

Calendars

Calendar region

Using a wizard to create a calendar

Modifying a calendar manually

Summary

Interactive Reports

Interactive Report Regions

Converting an Existing Report Region

Create an Interactive Report using a wizard

Manually modifying an Interactive Report

Linking to Interactive Reports

Summary

AJAX with APEX

The AJAX technology

AJAX implementation in APEX

Examples of using AJAX in APEX

Summary

Globalization and Localization With APEX Applications

A brief introduction to Globalization and Localization

Native IDE support of multiple languages

Multi-language support

Multi-lingual applications

Summary

Right-To-Left Support in APEX

Why we need special Right-To-Left support

Basic Right-To-Left scenarios

APEX templates with Right-To-Left support

The APEX Shuttle item

Labels and input fields alignment

Date and time

Summary

Deploying APEX Applications

What do we need to deploy?

Supporting Objects

Exporting an Application

Exporting a page

Exporting components

Importing an application

Command line export utility

Summary

The APEX Runtime Environment

What is the APEX Runtime Environment?

Setting up a Runtime Environment

Managing the APEX Runtime Environment

Summary

Security

APEX security features overview

Authentication Schemes

Authorization Schemes

Session state protection

Security Attributes

Summary

Application Conversion

APEX application conversion

Planning and understanding the application

APEX Application Migrations

Creating an APEX workspace

Converting Microsoft Access applications

Converting Oracle Forms applications

What's left to do?

Summary

APEX Best Practices

Don't re-invent the wheel

Learn the APEX IDE

Setting up workspaces

Application ID

Page numbering and page groups

Use Oracle naming conventions

Use bind variables

Don't hardcode, use Substitution Strings

Use PL/SQL packages

Re-useable code

Never change the provided APEX resources

Never trust the end user

Create your own restore point

Multi-user environment

Multi-lingual environment

Team development

Document development standards

Thou shall enter comments

APEX views (APEX dictionary)

APEX Application Reports

APEX Runtime-only version

Backup, backup, and more backup

Summary

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips

APEX Installation, Upgrade, and Configuration Tips