Oracle APEX 4.0 Cookbook

封面

Oracle APEX 4.0 Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files eBooks discount offers and more

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

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