Oracle APEX 4.0 Cookbook

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

• 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

• 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 Webservices
• Introduction
• Creating a SOAP webservice reference
• Creating a REST webservice reference
• Building a page on a webservice reference

• 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 Weblogic

• Chapter 11: APEX Administration
• Introduction
• Creating a workspace manually
• Creating a workspace by request
• Creating a user
• Adding a schema to your workspace
• Setting a system message
• Setting a workspace announcement
• Setting news items on the home page
• Creating a site-specific task list
• Creating a public theme
• Locking a workspace

• Chapter 12: Team Development
• Introduction
• Creating a list of features
• Creating and assigning To-do's
• Keeping track of bugs in the Bugtracker
• Creating Milestones
• Using Feedback
• Using Follow-ups

• Index