Oracle APEX 4.2 cookbook : create reliable, modern web applications for desktop and mobile devices with Oracle Application Express / Marcel van der Plas, Michel van Zoest
Cover; Copyright; Credits; About the Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Creating a Basic APEX Application; Introduction; Creating an APEX 4.0 application; Creating a simple form page; Creating a simple report; Implementing an interactive report; Creating a chart; Creating a map chart; Creating a navigation bar; Creating a list of values; Including different item types; Protecting a page using an authorization scheme; Securing an application with Authentication; Control the display of regions and items with Dynamic Actions
Creating a computationCreating an automated row fetch with a page process; Putting some validation in a form; Creating a report with PL/SQL Dynamic Content; Chapter 2:Themes and Templates; Introduction; Creating your own theme; Importing a theme; Creating a custom template; Including images in your application; Referencing CSS classes in your application; Controlling the layout; Chapter 3:Extending APEX; Introduction; Adding JavaScript code to your application; Creating a tag cloud with AJAX; Creating visual effects with JavaScript libraries; Enhancing your application with the Google API
Creating a region type plug-inCreating a dynamic action plug-in; Creating a process type plug-in; Creating an authorization plug-in; Chapter 6:Creating Multilingual APEX Applications; Introduction; Creating a translatable application; Using XLIFF files; Switching languages; Translating data in an application; Chapter 7:APEX APIs; Introduction; Updating a table with the hidden primary key; Reading a checkbox programmatically; Creating help functionality with apex_application.help; Counting clicks with apex_util.count_click; Setting default item settings with apex_ui_default_update
Creating a background process with apex_plsql_jobChapter 8:Using Web Services; Introduction; Creating a SOAP web service reference; Creating a REST web service reference; Building a page on a web service reference; Publishing a RESTful web service; Chapter 9:Publishing from APEX; Introduction; Exporting to a comma-separated file; Creating a PDF report; Creating a report query; Creating a report layout using Oracle BI Publisher; Linking the report layout to the report query; Calling a report from a page; Chapter 10:APEX Environment; Introduction ; Setting up a development environment using subscriptions
Summary
As a Cookbook, this book enables you to create APEX web applications and to implement features with immediately usable recipes that unleash the powerful functionality of Oracle APEX 4.2. Each recipe is presented as a separate, standalone entity and the reading of other, prior recipes is not required. It can be seen as a reference and a practical guide to APEX development. This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand. If you are new to APEX you will find recipes to start develo
