Book description
Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users.
The 13 authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product sing—developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding scalability, globalization, configuration and lifecycle management, and more. You'll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development.
Presents best-practices and development insights from leading experts in the field
Addresses globalization, scalability, security, and other concerns of enterprise-level development
Shows how to customize APEX for your own application needs
What you'll learn
Solve tough problems in scalability in order to serve thousands of users
Design applications to sidestep performance problems and easily scale upwards
Deploy applications globally while respecting linguistic and cultural differences
Customize applications by exploiting APEX's roots in PL/SQL
Reduce the stress of managing application lifecycle and configuration
Secure outwardly-facing applications and their data from intrusion
Who this book is for
Expert Oracle Application Express is aimed at APEX developers who seek the deepest possible knowledge of Oracle Application Express and how to develop with it. Readers should know and be proficient with APEX, and be prepared to expend some mental energy in absorbing the high-end material in this book.
Table of contents
- Copyright
- Foreword
- About the Authors
- About the Technical Reviewers
- Acknowledgments
- 1. OHS, EPG, and APEX Listener Compared
-
2. Oracle APEX 4.0 Charts Inside Out
- 2.1. HTML Charts
- 2.2. Flash Charts
- 2.3. Adding Multiple Series and Combined Charts
- 2.4. Different Flash Chart Types
- 2.5. Behind the Scenes
- 2.6. Debug and Performance
- 2.7. Upgrading Oracle APEX 3.x Flash and SVG Charts
- 2.8. Screen Reader Mode and Charts
- 2.9. Extending Flash Charts
- 2.10. Drill-Down Charts, Dashboards, and Interactivity
- 2.11. Most Common Issues
- 2.12. Charts in the Future
- 2.13. Resources
- 2.14. Conclusion
-
3. Tabular Forms
- 3.1. Changes in APEX 4.0
- 3.2. Constraints
- 3.3. Purpose of Tabular Forms
- 3.4. Tabular Forms Are Not Spreadsheets
- 3.5. New Features in APEX 4
- 3.6. Custom Coding in Tabular Forms
- 3.7. Interesting Techniques
- 3.8. Summary
-
4. Team Development
- 4.1. Milestones
- 4.2. Features
- 4.3. To Do's
- 4.4. Bugs
-
4.5. Feedback
- 4.5.1. Feedback Process
- 4.5.2. Enable Feedback
- 4.5.3. Exporting Feedback to Development
- 4.5.4. Importing Feedback into Development
- 4.5.5. Processing Feedback
- 4.5.6. Exporting Response to Deployment
- 4.5.7. Importing Response into Deployment
- 4.5.8. Extending Feedback: Create a Report
- 4.5.9. Extending Feedback: Feeding Back the Follow Up
- 4.5.10. Further Enhancements
- 4.6. Wrap Up
-
5. Globalization
- 5.1. Loading Languages
- 5.2. Translating Applications
- 5.3. Translating Data in the Database
- 5.4. Dynamic Translations
- 5.5. Translating APEX Internal Text
- 5.6. Copying Translations to Other Environments
- 5.7. Localization
- 5.8. Switching Languages
- 5.9. Translation logs
- 5.10. Conclusion
-
6. Debugging
- 6.1. Principles of Code Instrumentation
- 6.2. Debugging Basics
- 6.3. Benefits of Debug Mode
-
6.4. APEX Debugging API
-
6.4.1. APEX_DEBUG_MESSAGE
- 6.4.1.1. ENABLE_DEBUG_MESSAGES Procedure
- 6.4.1.2. DISABLE_DEBUG_MESSAGES Procedure
- 6.4.1.3. REMOVE_SESSION_MESSAGES Procedure
- 6.4.1.4. REMOVE_DEBUG_BY_APP Procedure
- 6.4.1.5. REMOVE_DEBUG_BY_AGE Procedure
- 6.4.1.6. REMOVE_DEBUG_BY_VIEW Procedure
- 6.4.1.7. LOG_MESSAGE Procedure
- 6.4.1.8. LOG_LONG_MESSAGE Procedure
- 6.4.1.9. LOG_PAGE_SESSION_STATE Procedure
- 6.4.2. Programmatic Debugging
- 6.4.3. Instrumenting Your Own Code
-
6.4.1. APEX_DEBUG_MESSAGE
- 6.5. The Data Behind Debugging
- 6.6. Debugging Dynamic Actions
- 6.7. What Debug Doesn't Capture
- 6.8. Summary
- 7. Dynamic Actions
- 8. Security
- 9. Lifecycle Management
- 10. Working with APEX Collections
- 11. Plug-Ins
- 12. Architecture
- 13. Advanced Interactive Reporting
Product information
- Title: Expert Oracle Application Express
- Author(s):
- Release date: May 2011
- Publisher(s): Apress
- ISBN: 9781430235125
You might also like
book
Agile Oracle Application Express
Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits …
book
Pro Oracle Application Express
Application Express, or APEX, is one of the most innovative products to come out of Oracle …
book
Expert Oracle Application Express Security
Expert Oracle Application Express Security covers all facets of security related to Oracle Application Express (APEX) …
book
Expert Oracle Application Express, Second Edition
Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight …