What this book covers

Chapter 1, Prepare and Build, discusses different aspects of setting up an Application Express (APEX) environment. Among others, we'll take a look at installing APEX, performing preparational tasks before actually building applications, and transforming the data model into initial screens. We will also discuss some guidelines and best practices for these phases.

Chapter 2, Leveraging the Database, explains various subjects related to an APEX environment. These subjects include instrumentation, efficient lookup tables, analytic and aggregate functions, offloading long running programs, and so on.

Chapter 3, Printing, deals with different aspects of printing in Oracle Application Express. In this chapter, we will discuss the two most used architectures in Application Express printing, using Apache FOP and Business Intelligence Publisher. Then, we will see how to install and configure both Apache FOP and Business Intelligence Publisher.

Chapter 4, Security, describes how to provide security for Oracle Application Express. In this chapter, we will discuss the responsibilities of an administrator. We will also discuss security aspects for developers.

Chapter 5, Debugging and Troubleshooting, discusses various subjects such as debugging in APEX, remote debugging using Oracle SQL Developer, reports available in Application Express for troubleshooting, and so on.

Chapter 6, Deploy and Maintain, discusses the deployment and maintenance of an APEX environment. In this chapter, we will discuss various topics such as considerations regarding packaging the application, version control, and so on.

Appendix, Database Cloud Service and APEX 4.2, discusses Oracle Public Cloud and the Application Express features in the Database Cloud Service and APEX 4.2.