PacktLib: Oracle APEX Best Practices

Oracle APEX Best Practices

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Preface

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

Leveraging the Database

Instrumentation

Efficient lookup tables

Analytic functions

Aggregate functions

Searching the contents of documents

Summary

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

Summary

Security

Securing Oracle Application Express for administrators

Virtual Private Database

Security considerations when installing Oracle Application Express

Security considerations for the developer

Summary

Debugging and Troubleshooting

Debugging an APEX page

APEX_APPLICATION.G_DEBUG

APEX and Oracle SQL Developer

Remote debugging

JavaScript console wrapper

Web development tools

Summary

Deploy and Maintain

Package your application, or not?

Deploying the database packages

Deploying the APEX application

Being active and proactive

Summary

Database Cloud Service and APEX 4.2

Database Cloud Service and APEX 4.2

Database Cloud Service and APEX 4.2

Index