Oracle APEX Best Practices

Make the most of Oracle Apex with this guide to best practices. It will help you look at the bigger picture when building applications and take more elements into account such as security and performance.

Oracle APEX Best Practices

Starting
Alex Nuijten, Iloon Ellen-Wolff, Learco Brizzi

Make the most of Oracle Apex with this guide to best practices. It will help you look at the bigger picture when building applications and take more elements into account such as security and performance.
$29.99
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Code Files
+ Collection

Book Details

ISBN 139781849684002
Paperback298 pages

About This Book

  • "Oracle APEX Best Practices" will get you started with Oracle APEX for developing real-world applications that perform and maximize the full potential of Oracle APEX
  • You will also learn to take advantage of advanced SQL and PL/SQL along the way
  • Combines the knowledge of Oracle Apex Experts -- Alex Nuijten, Iloon Ellen-Wollf, and Learco Brizzi
  • Setting up your environment and getting ready for developing applications

Who This Book Is For

This book is filled with best practices on how to make the most of Oracle APEX. Developers beginning with application development as well as those who are experienced will benefit from this book. You will need to have basic knowledge of SQL and PL/SQL to follow the examples in this book.

Table of Contents

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
Summary
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
Summary
Chapter 4: Security
Securing Oracle Application Express for administrators
Virtual Private Database
Security considerations when installing Oracle Application Express
Security considerations for the developer
Summary
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
Summary
Chapter 6: Deploy and Maintain
Package your application, or not?
Deploying the database packages
Deploying the APEX application
Being active and proactive
Summary

What You Will Learn

  • Lesser known features of SQL and PL/SQL
  • Incorporate printing capabilities
  • Create secure applications
  • Troubleshooting and Debugging
  • Setting up your environment
  • Best practices for building real life applications

In Detail

Have you ever wanted to create real-world database applications? In this book you’re not only getting APEX best practices, but will also take into account the total environment of an APEX application and benefit from it.

"Oracle APEX Best Practices" will guide you through the development of real-world applications. It will give you a broader view of APEX. The various aspects include setting up APEX environment, testing and debugging, security, and getting the best out of SQL and PL/SQL.

In six distinct chapters you will learn about different features of Oracle APEX as well as SQL and PL/SQL.

Do you maximize the capabilities of Oracle APEX? Do you use all the power that SQL and PL/SQL have to offer? Do you want to learn how to build a secure, fully functional application? Then this is the book you’ll need.

"Oracle APEX: Best Practices" is where practical development begins!

Authors

Table of Contents

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
Summary
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
Summary
Chapter 4: Security
Securing Oracle Application Express for administrators
Virtual Private Database
Security considerations when installing Oracle Application Express
Security considerations for the developer
Summary
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
Summary
Chapter 6: Deploy and Maintain
Package your application, or not?
Deploying the database packages
Deploying the APEX application
Being active and proactive
Summary

Book Details

ISBN 139781849684002
Paperback298 pages
Read More