Table of Contents
Preface
Chapter 1: Creating a Basic APEX Application
Chapter 2: Themes and Templates
Chapter 3: Extending APEX
Chapter 4: Creating Websheet Applications
Chapter 5: APEX Plug-ins
Chapter 6: Creating Multilingual APEX Applications
Chapter 7: APEX APIs
Chapter 8: Using Webservices
Chapter 9: Publishing from APEX
Chapter 10: APEX Environment
Chapter 11: APEX Administration
Chapter 12: Team Development
Index
- 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