更新时间：2021-08-05 18:45:38
coverpage
Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Support files eBooks discount offers and more
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Chapter 1. Prepare and Build
History and background
Installing APEX
Choosing a web server
Creating a second administrator
Database
Creating a workspace
User Interface Defaults
Page Zero
Structure of multiple applications
Creating applications
Summary
Chapter 2. Leveraging the Database
Instrumentation
Efficient lookup tables
Analytic functions
Aggregate functions
Searching the contents of documents
Chapter 3. Printing
Printing architecture
Installation and configuration of the Apache FOP report server
How to debug or troubleshoot printing issues
How to check if network services are enabled
Creating a report with BI Publisher
How to create a report that can deliver output in different formats
How to add a chart to a report
How to add dynamic images to a report
Print API
How to bypass the 32K limit
Alternatives to use for PDF printing
Plugins
Chapter 4. Security
Securing Oracle Application Express for administrators
Virtual Private Database
Security considerations when installing Oracle Application Express
Security considerations for the developer
Chapter 5. Debugging and Troubleshooting
Debugging an APEX page
APEX_APPLICATION.G_DEBUG
APEX and Oracle SQL Developer
Remote debugging
JavaScript console wrapper
Web development tools
Chapter 6. Deploy and Maintain
Package your application or not?
Deploying the database packages
Deploying the APEX application
Being active and proactive
Appendix A. Database Cloud Service and APEX 4.2
Oracle Public Cloud
Index
