Oracle APEX Cookbook（Second Edition）

封面

版权信息

Credits

About the Authors

About the Reviewers

www.PacktPub.com

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>

Controlling the display of regions and items with Dynamic Actions>

Creating a computation>

Creating 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>

Including Google Maps>

Embedding multimedia objects in your application>

Creating a region selector>

Sending mail via APEX>

Uploading and downloading files>

Calling APEX from an Oracle Form>

Creating a data upload page>

Using shipped files>

Chapter 4. Creating Websheet Applications

Introduction>

Creating a websheet application>

Creating a page in a websheet>

Adding a navigation section to a page>

Implementing a datagrid>

Allowing multiple users access to a websheet>

Creating an enhanced datagrid from a spreadsheet>

Chapter 5. APEX Plug-ins

Introduction>

Creating an item type plug-in>

Creating a region type plug-in>

Creating 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_job>

Chapter 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>

Debugging an APEX application>

Debugging an APEX application remotely>

Deploying an application with SQL Developer>

Setting up version control with APEX and SVN>

Setting up a production environment using an Apache proxy>

Setting up the APEX Listener on Tomcat>

Creating an error handling>