Log In
Or create an account ->
Imperial Library
Home
About
News
Upload
Forum
Help
Login/SignUp
Index
Cover
Title Page
Copyright
Dedication
Contents at a Glance
Contents
Foreword
About the Authors
About the Technical Reviewers
Acknowledgments
Chapter 1: OHS, EPG, and APEX Listener Compared
Why Should I Care About This Chapter?
Web Server Basics
The Oracle HTTP Server (OHS)
Installing the OHS
Configuring the OHS
Digging into HTTPD.CONF
Configuring Virtual Hosts
Prefork or Multi-Processing Module?
Web Server Compression
Expiry Headers
Embedded PL/SQL Gateway
Compression and Expiry Headers with the EPG
Configuring SHARED_SERVERS
Configuring EPG Parameters and DADS
Debugging Issues with the EPG
Configuring Virtual Hosts with the EPG
The APEX Listener
Stand-Alone Installation
Installing via Glassfish or Web Logic Server
Compression with the APEX Listener
Interesting APEX Listener Features
Conclusion
Chapter 2: Oracle APEX 4.0 Charts Inside Out
HTML Charts
Using the HTML Charts Wizard
The Result
Debugging and Performance
Behind the Scenes
Inline HTML Charts in Report
Flash Charts
Background
Creating a Flash Chart
The Result
Understanding the Chart Region
Understanding the Chart Attributes
Adding Multiple Series and Combined Charts
Different Flash Chart Types
Behind the Scenes
Debug and Performance
Upgrading Oracle APEX 3.x Flash and SVG Charts
Screen Reader Mode and Charts
Extending Flash 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
Most Common Issues
Search for a Specific Feature
Invalid #HOST# with Reverse Proxy or HTTPS
Flash Security Error
Charts in the Future
Resources
Conclusion
Chapter 3: Tabular Forms
Changes in APEX 4.0
Constraints
Purpose of Tabular Forms
Tabular Forms Are Not Spreadsheets
New Features in APEX 4
New Item Types
Declarative Validations
Other Features
Future Features We'd Like to See
Custom Coding in Tabular Forms
Processing the Correct Rows
Data Integrity
Manual Tabular Forms
Tabular Forms and Collections
Interesting Techniques
Simple Autocomplete
Autocomplete Returning Key Value
Clone Rows
Summary
Chapter 4: 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
Processing Feedback
Exporting Response to Deployment
Importing Response into Deployment
Extending Feedback: Create a Report
Extending Feedback: Feeding Back the Follow Up
Further Enhancements
Wrap Up
Chapter 5: Globalization
Loading 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
Copying Translations to Other Environments
Copying Only the Applications
Copy the Primary Application and Publish
Changing the Application ID
Localization
SINCE Format Mask
Numeric Formats
Time Zones and Territories
Switching Languages
Translation logs
Developer Log
Dashboard
Conclusion
Chapter 6: 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_MESSAGE
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
What Debug Doesn't Capture
AJAX Calls
FLASH Charts
Reports
Summary
Chapter 7: Dynamic Actions
Custom JavaScript vs. Dynamic Actions
Manual (Old Method)
Dynamic Action (New Method)
Dynamic Actions in Detail
Identification
When
Advanced
Actions
Dynamic Actions in Action
Business Case
Setup
Create Department Employee Report
Refresh Department Employees Report
Highlight Row
Row Click
Emphasize Employee Change
Modal Window
Summary
Chapter 8: Security
Tools and Techniques
Authorized Access
An APEX Example
The Real Solution
Denial of Service
Denial of Service in an APEX Environment
The Details
The Fix
SQL Injection
A SQL Injection Primer
Custom Developed Applications vs. Commercial Off the Shelf Products
SQL Injection in an APEX Environment
Password Cracking
Cross Site Scripting
Conclusion
Chapter 9: Lifecycle Management
Challenges
Working Concurrently on the Same Source Code
Propagating All Required Changes for a New Release
Parallel Development on Different Application Versions
What Is the Current Status?
Which Requirements Were Implemented in This Release?
The Sample Application
The Approach
Version Numbering Scheme and the Overall Delivery Process
Storing Files on the Application Server
Requirements for Designing the Server Environments
Project Management Related Aspects
Version Control
Naming Conventions
Naming Conventions for the File System
Rollout Procedures
Initialize Patch
Making Changes
Finalizing the Patch
Installation in the Test Environment
Update the Documentation
Installation in the Production Environment
Summary
Chapter 10: 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 Contents
Expanding Our Example
Passing Data to the Form
Creating a Tabular Form to Be Validated
Collecting and Processing Submitted Data
Summary
Chapter 11: Plug-Ins
The APEX Plug-in Architecture
Create/Edit Page for Plug-ins
PL/SQL APIs
Other Tools of the Trade
jQuery UI Widget Factory
jQuery UI CSS Framework
Plug-in Tutorials
Developing a Process Plug-in
Developing a Dynamic Action Plug-in
Developing an Item Plug-in
Developing a Region Plug-in
Best Practices for Developing Plug-ins
Conclusion
Chapter 12: Architecture
Oracle APEX Engine
Installing and Upgrading
Applications
Application Pages
Session State Management
Connection Management
Application Logging
Running SQL and PL/SQL Contained Within an Application
Workspaces and Multi-Tenancy
Automatic Data Manipulation Language (DML)
Application Extensibility
Customizing User Interface Templates
Using Static HTML
Using PL/SQL to Generate HTML
Plug-Ins
Separation of Presentation and Logic
Conclusion
Chapter 13: Advanced Interactive Reporting
Creating a Report
Data Formatting
Report and Column Attributes
Column Groups
Including Links
Filtering Using Items
Column List of Values
Creating Default and Saved Reports
Charting
Linking to Saved Interactive Reports
Report Settings
Report-Level Settings
Column-Level Settings
Utilities
APEX_UTIL functions
User Interface Defaults
Activity Log
Security
Performance
Conclusion
Index
← Prev
Back
Next →
← Prev
Back
Next →