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
