Book Image

Oracle APEX Best Practices

Book Image

Oracle APEX Best Practices

Overview of this book

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!
Table of Contents (14 chapters)
Oracle APEX Best Practices
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

APEX and Oracle SQL Developer


APEX and Oracle SQL Developer can work perfectly together. For troubleshooting PL/SQL code within APEX, remote debugging can be very handy.

Oracle SQL Developer is a graphical user interface that allows you to browse database objects, run SQL statements and scripts, and debug PL/SQL statements. Before concentrating on the integration of Oracle SQL Developer and APEX, we are going to look at how debugging is done in Oracle SQL Developer. Oracle provides two packages for debugging PL/SQL code. The first, DBMS_DEBUG, was introduced in Oracle version 8i and not used anymore in Oracle SQL Developer. The second, DBMS_DEBUG_JDWP, was introduced in Oracle version 9i and is used by Oracle SQL Developer.

More information and downloads of Oracle SQL Developer can be found at:

http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

To demonstrate debugging with Oracle SQL Developer, create the following procedure:

Note

The procedure is for demonstrations...