You are previewing Pro Oracle Application Express.
O'Reilly logo
Pro Oracle Application Express

Book Description

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing database–backed applications. It's easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers aren't left out, however. Those who choose to do so can go deep and leverage the full power and flexibility of Oracle's database engine.

Getting started with APEX is easy; learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the "hood" of APEX and expose the full power behind its easy–to–use GUI. They show you what you need to know to produce powerful, professionally polished applications—such as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

The authors are well–qualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hard–core APEX developer. His co-author, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their full-time careers on developing APEX applications. Pro Oracle Application Express is your opportunity to learn APEX from the very best.

Table of Contents

  1. Title Page
  2. Contents at a Glance
  3. Contents
  4. Foreword
  5. About the Authors
  6. About the Technical Reviewer
  7. Acknowledgments
  8. Preface
  9. CHAPTER 1: Development Best Practices
    1. APEX Installation Decisions
    2. Application Development Considerations
    3. Performance Considerations
    4. Summary
  10. CHAPTER 2: Migrating to APEX from Desktop Systems
    1. Excel Migration
    2. Access Migration
    3. Migration from Other Systems
    4. Migration with SQL Developer
    5. Summary
  11. CHAPTER 3: Authentication and User Management
    1. Preconfigured Authentication Schemes
    2. Open Door Credentials
    3. No Authentication
    4. Application Express Account Credentials
    5. Database Account Authentication
    6. Custom Authentication
    7. Implementing Session Timeouts
    8. Summary
  12. CHAPTER 4: Conditions and Authorization Schemes
    1. Conditions
    2. Authorization Schemes
    3. Summary
  13. CHAPTER 5: Data Security
    1. URLs and Security
    2. Session State Protection
    3. Virtual Private Database
    4. Auditing
    5. Summary
  14. CHAPTER 6: Navigation and Layout
    1. Tabs
    2. Navigation Bars
    3. Breadcrumbs
    4. Lists
    5. Trees
    6. Page Zero
    7. Layout
    8. Summary
  15. CHAPTER 7: Reports and Charts
    1. Reports
    2. Charts
    3. Summary
  16. CHAPTER 8: Ajax and JavaScript
    1. Implementing an Ajax Search
    2. Calling On Demand Processes
    3. Showing and Hiding Page Elements
    4. Implementing Third-Party Ajax Libraries
    5. Summary
  17. CHAPTER 9: File Storage
    1. Database or File System?
    2. Using Standard Procedures
    3. Creating Custom Procedures
    4. Image Caching
    5. Summary
  18. CHAPTER 10: Reporting and Printing
    1. Choosing a Print Server
    2. Configuring APEX to Use a Print Server
    3. Printing Reports
    4. Creating Custom Report Layouts with BI Publisher
    5. Generating Reports Through Apache FOP
    6. Summary
  19. CHAPTER 11: Themes and Templates
    1. Themes
    2. Templates
    3. Template Subscriptions
    4. Tools for Working with Templates
    5. Summary
  20. CHAPTER 12: Localization Issues
    1. Localizing Application Builder
    2. Localizing Your Applications
    3. Fully Translating Your Applications
    4. Summary
  21. CHAPTER 13: LDAP and Single Sign-On
    1. LDAP Schema
    2. Benefits of Using LDAP
    3. Authentication with LDAP
    4. Integrating with Legacy LDAP Schema
    5. Working with Groups in OID
    6. Working with Groups in Microsoft Active Directory
    7. Querying and Updating LDAP Attributes
    8. Using Single Sign-On
    9. Summary
  22. CHAPTER 14: Performance and Scalability
    1. Diagnosing Performance Problems
    2. Making Your Applications More Scalable
    3. Summary
  23. CHAPTER 15: Production Issues
    1. Managing URLs
    2. Backing Up Applications
    3. Migrating Between Environments
    4. Summary
  24. CHAPTER 16: APEX Dictionary
    1. Accessing the APEX Dictionary
    2. Uses for the APEX Dictionary
    3. Using the API
    4. Summary
  25. Index