SUMMARY

SEARCH

Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.

BOOK EXPERT ORACLE APPLICATION EXPRESS, 2ND EDITION

SUMMARY

646

Chapter 1: Page Designer
Main Components
Navigation
Page Finder Icon
Lock Pages and Undo and Redo Icons
Create,Utilities,and Component View Icons
Component View
Rendering
Dynamic Actions
Processing
Page Shared Components
Grid Layout
Grid Layout
Messages
Page Search
Help
Property Editor
Show Common
Show All
Collapse All
Show All
Quick Pick,Go to Group,and Go to Component Icons
Code Editor
Shortcuts
Help Functionalities
Link to the APEX 5.0 Documentation
Link to the APEX 5.0 Forum at OTN
Link to the APEX Resources at OTN
Page Designer Help: Getting Started in Page Designer
About Page Designer
Other Options
Multiple Component Selection
Resizing Page Designer Areas
Page Designer Memory Function
Page Designer Toolbar Options
Chapter 2: Oracle REST Data Services
ORDS Defined
ORDS Download and Setup
Running the Install
Database Users Used by ORDS
Configuring Multiple Databases
Configuration Files
Administration via SQL Developer
ORDS Development via SQL Developer
REST Enabling an Existing Table
Invoking the New REST Service
Creating a REST Web Service
Accessing Hidden Parameters
Accessing ORDS Web Services via APEX
Chapter 3: Oracle APEX 5.0 Charts Inside Out
HTML5 Charts
Background
Creating a Chart
The Result
Page Designer vs. Component View
Understanding the Chart Region
Understanding the Chart Attributes
Adding Multiple Series and Combined Charts
Different Chart Types
Behind the Scenes
Debug and Performance
Upgrading Oracle APEX 3.x/4.x Flash and SVG Charts
Screen Reader Mode and Charts
Extending Charts
Customizing Charts by Using Custom XML
Customizing Charts by Using Custom XML,Dynamic Actions,and JavaScript
Creating Charts Manually
Drill-Down Charts,Dashboards,and Interactivity
Simple Dashboard with Submit
Simple Dashboard with JavaScript
Complex Dashboard with Actions
Building Charts with the AnyChart Plugin
Most Common Issues
Chart Not Rendering Correctly
Search for a Specific Feature
Charts in the Future
Chart Plugins
Sample Charts in Packaged Application
Inline Charts in Report
Resources
Chapter 4: Tabular Forms
Changes in APEX 4.0
Changes in APEX 4.1/4.2
Changes in APEX 5.0
Constraints
Purpose of Tabular Forms
Tabular Forms Are Not Spreadsheets
Features in APEX 4
New Item Types
Declarative Validations
Other Features
Features in APEX 4.1/4.2
New Validation Types for Tabular Forms
New Variables Available for the Processing
Tabular Forms and Dynamic Actions
Custom Coding in Tabular Forms
Processing the Correct Rows
Data Integrity
Manual Tabular Forms
Tabular Forms and Collections
Interesting Techniques
Multiple Tabular Forms and Modal Pages
Adding Cascading Select Lists to a Tabular Form
Chapter 5: Team Development
Milestones
The Basics
Extending Milestone Functionality
Features
The Basics
Extending the Features Functionality
To Do’s
The Basics
Extending the To-Do Functionality
Bugs
Feedback
Feedback Process
Enable Feedback
Exporting Feedback to Development
Importing Feedback into Development
Team Development Integration in the Page Designer
Processing Feedback
Exporting Response to Deployment
Importing Response into Deployment
Extending Feedback: Creating a Report
Extending Feedback: Feeding Back the Follow-Up
Further Enhancements
Chapter 6: Globalization
Using the Builder in Other Languages
Translating Applications
Application Language Derived From
Mapping
CSV Encoding
Translating an Application
Manually Translate an Application
Translating Data in the Database
Dynamic Translations
Translating APEX Internal Text
The APEX_LANG API
Copying Translations to Other Environments
Export/Import the Primary Application with the Translations
Export/Import the Primary Application and the Translated Applications Separately
Export Only the Primary Application and the XLIFF
Localization
SINCE Format Mask
Numeric Formats
Time Zones and Territories
Switching Languages
Chapter 7: Debugging
Principles of Code Instrumentation
Debugging Basics
Page Processing and Rendering
Enabling Debug
Debug Information
Benefits of Debug Mode
Graphs and Charts
Interactive Reports
APEX Debugging API
APEX_DEBUG
Programmatic Debugging
Instrumenting Your Own Code
The Data Behind Debugging
Tables and View
Examining the Debug Data
Using Debug Data for More Than Debugging
Debugging Dynamic Actions
Debugging Plugins
Chapter 8: Dynamic Actions
Custom JavaScript vs. Dynamic Actions
Manual (Custom JavaScript) Method
Dynamic Action Method
Dynamic Actions in Detail
Identification
Execution Options
When
Advanced
Actions
Dynamic Actions in Action
Business Case
Setup
Create Department Employees Report
Refresh Department Employees Report
Highlight Row
Row Click
Emphasize Employee Change
Modal Window
Chapter 9: Lifecycle Management
Challenges
Deploying Database Changes
Collaborative Development
Parallel Development
Enterprise APEX Development
The Demo Project
Extending the APEX Development and Deployment Process
APEX Application Packaging
Apache Maven
Liquibase
The Oracle APEX Maven Plugin
Deploying Static Files
Multi-environment Setup
Building with Maven to Multiple Environments
One Code Base to Rule Them All
Jenkins
Chapter 10: Plugins
The APEX Plugin Architecture
Create/Edit Page for Plugins
PL/SQL APIs
Other Tools of the Trade
jQuery and jQuery UI
jQuery UI Widget Factory
Font Awesome
Building a Region Plugin
The Base Plugin
File Setup
Initial Grid Render
Adjusting the UI for APEX
Getting Set Up for Success
Bringing on the AJAX
Using User-Specified Queries
Enabling Frozen Columns
Securing the Plugin
Best Practices for Developing Plugins
Chapter 11: jQuery with APEX
JavaScript and jQuery
Basics of jQuery
The jQuery Object
Selecting Elements
DOM Nodes and jQuery Objects
Determining and Testing Selectors
Basic Manipulations
Iterating Over a Selection of Elements
Advanced Uses of jQuery
Handling Events
Traversing the DOM
Chaining Functions
APEX JavaScript APIs
AJAX Calls and AJAX Callback Processes
jQuery Versions
apex.jQuery
Pitfalls
Resources
Chapter 12: Map Integration
Geocoding
Coordinates
Web Services
What Are XML and JSON?
Processing XML/JSON Results
Oracle Web Services
Choosing a Geocoding Service
The Mapping API
Including the API Libraries
Creating a div to Hold the Map
Writing JavaScript to Render the Map
Adding Layers
Interacting with the Database
Showing Query Results on a Map
Spatial Math
SDO_GEOMETRY
SDO Metadata
Spatial Indexes
APEX_SPATIAL Package
Calculating Distance
Search Within Distance
Calculate Area
Third-Party Data
Chapter 13: Themes and Templates
What Is a Template?
What Is a Theme?
Component Defaults
Region Defaults
Dialog Defaults
The Substitution Strings
Finding Substitution Strings in the Application
Theme Styles
The Theme Roller
Template Options
The Grid
Responsive Layout
Subregions
Theme Subscriptions
Chapter 14: Report Printing
Introduction
Report Printing
APEX Standard Report Printing
Prerequisites
Standard Report Printing Configuration
FOP Processor in ORDS
External FOP Processor
Enable Network Services
APEX Standard Report Printing
Classic Report Printing
Column Width Settings
Interactive Report PDF Output
Report Queries and Report Layouts
Report Query
Report Layouts
XSL-FO 101
XSL-FO
The XML
FO Document Structure
Customized PDF Output for Interactive Reports
Advanced XSL-FO Examples
Conditional Formatting
Conditional Formatting
XSL-FO Editors
Debugging XSL-FO
Third-Party Report Printing Solutions
General Report Printing Solutions
The Future
Chapter 15: Working with APEX Collections
When to Use APEX Collections
Session State Management: A Quick Overview
Session State–Managed Tables
Logically Walking Through a Web Shopping Cart Implementation
A Look Under the Covers
Private Collections Objects Inside the APEX Engine
Public Collections Objects Inside the APEX Engine
Getting Started with Collections
Initializing a Collection
Adding and Removing Data from Collections
Using the Collection
Exploring Another Use Case
Expanding the Example
Setting Up the Example
Chapter 1: Page Designer
Main Components
Navigation
Page Finder Icon
Lock Pages and Undo and Redo Icons
Create,Utilities,and Component View Icons
Component View
Rendering
Dynamic Actions
Processing
Page Shared Components
Grid Layout
Grid Layout
Messages
Page Search
Help
Property Editor
Show Common
Show All
Collapse All
Show All
Quick Pick,Go to Group,and Go to Component Icons
Code Editor
Shortcuts
Help Functionalities
Link to the APEX 5.0 Documentation
Link to the APEX 5.0 Forum at OTN
Link to the APEX Resources at OTN
Page Designer Help: Getting Started in Page Designer
About Page Designer
Other Options
Multiple Component Selection
Resizing Page Designer Areas
Page Designer Memory Function
Page Designer Toolbar Options
Chapter 2: Oracle REST Data Services
ORDS Defined
ORDS Download and Setup
Running the Install
Database Users Used by ORDS
Configuring Multiple Databases
Configuration Files
Administration via SQL Developer
ORDS Development via SQL Developer
REST Enabling an Existing Table
Invoking the New REST Service
Creating a REST Web Service
Accessing Hidden Parameters
Accessing ORDS Web Services via APEX
Chapter 3: Oracle APEX 5.0 Charts Inside Out
HTML5 Charts
Background
Creating a Chart
The Result
Page Designer vs. Component View
Understanding the Chart Region
Understanding the Chart Attributes
Adding Multiple Series and Combined Charts
Different Chart Types
Behind the Scenes
Debug and Performance
Upgrading Oracle APEX 3.x/4.x Flash and SVG Charts
Screen Reader Mode and Charts
Extending Charts
Customizing Charts by Using Custom XML
Customizing Charts by Using Custom XML,Dynamic Actions,and JavaScript
Creating Charts Manually
Drill-Down Charts,Dashboards,and Interactivity
Simple Dashboard with Submit
Simple Dashboard with JavaScript
Complex Dashboard with Actions
Building Charts with the AnyChart Plugin
Most Common Issues
Chart Not Rendering Correctly
Search for a Specific Feature
Charts in the Future
Chart Plugins
Sample Charts in Packaged Application
Inline Charts in Report
Resources
Chapter 4: Tabular Forms
Changes in APEX 4.0
Changes in APEX 4.1/4.2
Changes in APEX 5.0
Constraints
Purpose of Tabular Forms
Tabular Forms Are Not Spreadsheets
Features in APEX 4
New Item Types
Declarative Validations
Other Features
Features in APEX 4.1/4.2
New Validation Types for Tabular Forms
New Variables Available for the Processing
Tabular Forms and Dynamic Actions
Custom Coding in Tabular Forms
Processing the Correct Rows
Data Integrity
Manual Tabular Forms
Tabular Forms and Collections
Interesting Techniques
Multiple Tabular Forms and Modal Pages
Adding Cascading Select Lists to a Tabular Form
Chapter 5: Team Development
Milestones
The Basics
Extending Milestone Functionality
Features
The Basics
Extending the Features Functionality
To Do’s
The Basics
Extending the To-Do Functionality
Bugs
Feedback
Feedback Process
Enable Feedback
Exporting Feedback to Development
Importing Feedback into Development
Team Development Integration in the Page Designer
Processing Feedback
Exporting Response to Deployment
Importing Response into Deployment
Extending Feedback: Creating a Report
Extending Feedback: Feeding Back the Follow-Up
Further Enhancements
Chapter 6: Globalization
Using the Builder in Other Languages
Translating Applications
Application Language Derived From
Mapping
CSV Encoding
Translating an Application
Manually Translate an Application
Translating Data in the Database
Dynamic Translations
Translating APEX Internal Text
The APEX_LANG API
Copying Translations to Other Environments
Export/Import the Primary Application with the Translations
Export/Import the Primary Application and the Translated Applications Separately
Export Only the Primary Application and the XLIFF
Localization
SINCE Format Mask
Numeric Formats
Time Zones and Territories
Switching Languages
Chapter 7: Debugging
Principles of Code Instrumentation
Debugging Basics
Page Processing and Rendering
Enabling Debug
Debug Information
Benefits of Debug Mode
Graphs and Charts
Interactive Reports
APEX Debugging API
APEX_DEBUG
Programmatic Debugging
Instrumenting Your Own Code
The Data Behind Debugging
Tables and View
Examining the Debug Data
Using Debug Data for More Than Debugging
Debugging Dynamic Actions
Debugging Plugins
Chapter 8: Dynamic Actions
Custom JavaScript vs. Dynamic Actions
Manual (Custom JavaScript) Method
Dynamic Action Method
Dynamic Actions in Detail
Identification
Execution Options
When
Advanced
Actions
Dynamic Actions in Action
Business Case
Setup
Create Department Employees Report
Refresh Department Employees Report
Highlight Row
Row Click
Emphasize Employee Change
Modal Window
Chapter 9: Lifecycle Management
Challenges
Deploying Database Changes
Collaborative Development
Parallel Development
Enterprise APEX Development
The Demo Project
Extending the APEX Development and Deployment Process
APEX Application Packaging
Apache Maven
Liquibase
The Oracle APEX Maven Plugin
Deploying Static Files
Multi-environment Setup
Building with Maven to Multiple Environments
One Code Base to Rule Them All
Jenkins
Chapter 10: Plugins
The APEX Plugin Architecture
Create/Edit Page for Plugins
PL/SQL APIs
Other Tools of the Trade
jQuery and jQuery UI
jQuery UI Widget Factory
Font Awesome
Building a Region Plugin
The Base Plugin
File Setup
Initial Grid Render
Adjusting the UI for APEX
Getting Set Up for Success
Bringing on the AJAX
Using User-Specified Queries
Enabling Frozen Columns
Securing the Plugin
Best Practices for Developing Plugins
Chapter 11: jQuery with APEX
JavaScript and jQuery
Basics of jQuery
The jQuery Object
Selecting Elements
DOM Nodes and jQuery Objects
Determining and Testing Selectors
Basic Manipulations
Iterating Over a Selection of Elements
Advanced Uses of jQuery
Handling Events
Traversing the DOM
Chaining Functions
APEX JavaScript APIs
AJAX Calls and AJAX Callback Processes
jQuery Versions
apex.jQuery
Pitfalls
Resources
Chapter 12: Map Integration
Geocoding
Coordinates
Web Services
What Are XML and JSON?
Processing XML/JSON Results
Oracle Web Services
Choosing a Geocoding Service
The Mapping API
Including the API Libraries
Creating a div to Hold the Map
Writing JavaScript to Render the Map
Adding Layers
Interacting with the Database
Showing Query Results on a Map
Spatial Math
SDO_GEOMETRY
SDO Metadata
Spatial Indexes
APEX_SPATIAL Package
Calculating Distance
Search Within Distance
Calculate Area
Third-Party Data
Chapter 13: Themes and Templates
What Is a Template?
What Is a Theme?
Component Defaults
Region Defaults
Dialog Defaults
The Substitution Strings
Finding Substitution Strings in the Application
Theme Styles
The Theme Roller
Template Options
The Grid
Responsive Layout
Subregions
Theme Subscriptions
Chapter 14: Report Printing
Introduction
Report Printing
APEX Standard Report Printing
Prerequisites
Standard Report Printing Configuration
FOP Processor in ORDS
External FOP Processor
Enable Network Services
APEX Standard Report Printing
Classic Report Printing
Column Width Settings
Interactive Report PDF Output
Report Queries and Report Layouts
Report Query
Report Layouts
XSL-FO 101
XSL-FO
The XML
FO Document Structure
Customized PDF Output for Interactive Reports
Advanced XSL-FO Examples
Conditional Formatting
Conditional Formatting
XSL-FO Editors
Debugging XSL-FO
Third-Party Report Printing Solutions
General Report Printing Solutions
The Future
Chapter 15: Working with APEX Collections
When to Use APEX Collections
Session State Management: A Quick Overview
Session State–Managed Tables
Logically Walking Through a Web Shopping Cart Implementation
A Look Under the Covers
Private Collections Objects Inside the APEX Engine
Public Collections Objects Inside the APEX Engine
Getting Started with Collections
Initializing a Collection
Adding and Removing Data from Collections
Using the Collection
Exploring Another Use Case
Expanding the Example
Setting Up the Example