Book Image

Oracle Application Express 3.2 - The Essentials and More

Book Image

Oracle Application Express 3.2 - The Essentials and More

Overview of this book

Developing data-centric web applications can be a real challenge as it is a multi-disciplinary process. There are many technologies involved in the client side (HTML, CSS, JavaScript, and so on); the interaction with the database, on the server side; the typeless nature of the web environment; and above all, the need to put it all together. This needs to be done in a manner that will allow the end users to do their job in the simplest and most efficient way, while enriching their user experience. How often have you wished that developing such applications could be uncomplicated and straightforward? This book will show you that it's possible, and teaches you how to do it, using Oracle Application Express (APEX).With this practical guide to APEX, you'll learn how to easily develop data-centric web applications for the Oracle environment. The book covers the development cycle of an APEX application, reviewing the major APEX principles and building blocks chapter by chapter. It starts with the basic skills you need to get going when developing with APEX. Later, you will learn advanced issues, such as how to build tailor-made forms and reports, using APEX APIs, AJAX, and so on. It not only deals with the "How" but also with the "Why", and before long you will be able to understand APEX concepts, and use them to expand and enhance the built-in features, wizards, and tools.The book starts with the design phase, including building the necessary database objects infrastructure; continues with ways to implement the application logic (on the server side) and the User Interface (on the client side), whilst showing you how to enhance your applications' features and functionality according to your specific needs; and it ends with application deployment.The book emphasizes and clearly documents areas such as Globalization, Localization, and developing multi-lingual applications, and includes a special discussion about Right-To-Left (RTL) support for APEX applications, documented here for the first time.Throughout the book, there are many screenshots and snippets of code, taken from working APEX applications. The book is accompanied by demo APEX applications that you can download and install in your APEX environment, thoroughly analyze, and learn from as you read the book.
Table of Contents (30 chapters)
Oracle Application Express 3.2
Credits
About the Authors
About the Reviewers
Preface

Data Centric


APEX was designed to produce applications that store, retrieve, manipulate, and display data, from Oracle Databases. This means that if your application's main logic doesn't revolve around data manipulation, it may be that APEX is not your optimal application development tool. However, if data manipulation is at the heart of your application, APEX could be your best bet.

APEX is actually a collection of PL/SQL packages, which "live" inside the Oracle database. It means that APEX automatically inherits all the outstanding features, often mentioned with regards to the Oracle database environment: high performance, robustness, reliability, enhanced security, scalability, and more. In addition, APEX can natively utilize the very rich SQL and PL/SQL environment, including the built-in packages that the Oracle database has to offer, and use them to manipulate the data in the optimal ways a RDBMS can offer.

Moreover, APEX can utilize special functionality features that are included in the various database versions and editions, like Oracle XML DB, Oracle Text, and Oracle Multimedia.

Another advantage in this context is that, like the client side which relies on Web browsers to gain hardware independence, (alongside operating system independence), the APEX engine relies on the database platform for the same purpose. As long as we have a proper running version of an Oracle database, starting with Oracle database 9.2.0.3 and above (including the free version, Oracle XE), we can ignore the hardware and operating systems aspects of the server.