Oracle APEX 4.2 Cookbook : Second Edition电子书

Oracle APEX Cookbook Second Edition

Table of Contents

Oracle APEX Cookbook Second Edition

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Instant Updates on New Packt Books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Creating a Basic APEX Application

Introduction

Creating an APEX 4.0 application

How to do it...

How it works...

Creating a simple form page

Getting ready

How to do it...

How it works...

There's more…

Creating a simple report

Getting ready

How to do it...

How it works...

See also

Implementing an interactive report

Getting ready

How to do it...

There's more...

Creating a chart

Getting ready

How to do it...

There's more...

Creating a map chart

Getting ready

How to do it...

How it works...

There's more...

Creating a navigation bar

Getting ready

How to do it...

There's more...

See also

Creating a list of values

Getting ready

How to do it...

How it works...

There's more...

Including different item types

Getting ready

How to do it...

Protecting a page using an authorization scheme

Getting ready

How to do it...

How it works...

There's more...

Securing an application with Authentication

Getting ready

How to do it...

Controlling the display of regions and items with Dynamic Actions

Getting ready

How to do it...

How it works...

There's more...

Creating a computation

How to do it...

There's more...

Creating an automated row fetch with a page process

Getting ready

How to do it...

How it works...

Putting some validation in a form

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a report with PL/SQL Dynamic Content

How to do it...

2. Themes and Templates

Introduction

Creating your own theme

Getting ready

How to do it...

How it works...

Importing a theme

Getting ready

How to do it...

How it works...

Creating a custom template

Getting ready

How to do it...

There's more...

Including images in your application

Getting ready

How to do it...

How it works...

There's more...

Referencing CSS classes in your application

Getting ready

How to do it...

How it works...

Controlling the layout

Getting ready

How to do it...

How it works...

There's more...

3. Extending APEX

Introduction

Adding JavaScript code to your application

Getting ready

How to do it...

How it works...

There's more...

Creating a tag cloud with AJAX

Getting ready

How to do it...

How it works...

Creating visual effects with JavaScript libraries

Getting ready

How to do it...

How it works...

There's more...

Enhancing your application with the Google API

How to do it...

How it works...

There's more...

See also

Including Google Maps

Getting ready

How to do it...

How it works...

There's more...

See also

Embedding multimedia objects in your application

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a region selector

Getting ready

How to do it...

How it works...

Sending mail via APEX

Getting ready

How to do it...

How it works...

Uploading and downloading files

Getting ready

How to do it...

How it works...

There's more...

Calling APEX from an Oracle Form

Getting ready

How to do it...

How it works...

There's more...

Creating a data upload page

Getting ready

How to do it...

Using shipped files

Getting ready

How to do it...

How it works...

There's more...

4. Creating Websheet Applications

Introduction

Creating a websheet application

Getting ready

How to do it...

How it works...

See also

Creating a page in a websheet

Getting ready

How to do it...

Adding a navigation section to a page

Getting ready

How to do it...

Implementing a datagrid

Getting ready

How to do it...

How it works...

See also

Allowing multiple users access to a websheet

Getting ready

How to do it...

How it works...

Creating an enhanced datagrid from a spreadsheet

How to do it...

There's more...

5. APEX Plug-ins

Introduction

Creating an item type plug-in

Getting ready

How to do it...

How it works...

There's more...

Creating a region type plug-in

Getting ready

How to do it...

How it works...

See also

Creating a dynamic action plug-in

Getting ready

How to do it...

How it works...

Creating a process type plug-in

Getting ready

How to do it...

See also

Creating an authorization plug-in

Getting ready

How to do it…

How it works...

There's more…

6. Creating Multilingual APEX Applications

Introduction

Creating a translatable application

Getting ready

How to do it...

See also

Using XLIFF files

Getting ready

How to do it...

How it works...

Switching languages

Getting ready

How to do it...

Translating data in an application

Getting ready

How to do it...

How it works...

7. APEX APIs

Introduction

Updating a table with the hidden primary key

Getting ready

How to do it...

How it works...

Reading a checkbox programmatically

Getting ready

How to do it...

Creating help functionality with apex_application.help

Getting ready

How to do it...

How it works...

There's more...

Counting clicks with apex_util.count_click

Getting ready

How to do it...

How it works...

There's more...

Setting default item settings with apex_ui_default_update

Getting ready

How to do it...

How it works...

There's more...

Creating a background process with apex_plsql_job

Getting ready

How to do it...

How it works...

There's more...

8. Using Web Services

Introduction

Creating a SOAP web service reference

Getting ready

How to do it...

How it works...

See also

Creating a REST web service reference

Getting ready

How to do it...

How it works…

There's more…

Building a page on a web service reference

Getting ready

How to do it…

How it works…

There's more…

Publishing a RESTful web service

Getting ready

How to do it…

There's more…

See also

9. Publishing from APEX

Introduction

Exporting to a comma-separated file

Getting ready

How to do it...

How it works...

Creating a PDF report

Getting ready

How to do it...

How it works...

There's more...

Creating a report query

Getting ready

How to do it...

How it works...

Creating a report layout using Oracle BI Publisher

Getting ready

How to do it...

How it works...

Linking the report layout to the report query

Getting ready

How to do it...

How it works...

Calling a report from a page

Getting ready

How to do it...

How it works...

10. APEX Environment

Introduction

Setting up a development environment using subscriptions

How to do it...

Debugging an APEX application


Getting ready

How to do it...

There's more...

Debugging an APEX application remotely

Getting ready

How to do it...

How it works...

There's more…

Deploying an application with SQL Developer

Getting ready

How to do it...

Setting up version control with APEX and SVN

Getting ready

How to do it...

Setting up a production environment using an Apache proxy

Getting ready

How to do it...

Setting up the APEX Listener on Tomcat

Getting ready

How to do it...

There's more…

Creating an error handling

Getting ready

How to do it…

How it works...

Using packaged applications

Getting ready

How to do it...

11. APEX Administration

Introduction

Creating a workspace manually

Getting ready

How to do it...

How it works...

Creating a workspace by request

Getting ready

How to do it...

There's more...

Creating a user

Getting ready

How to do it...

Adding a schema to your workspace

Getting ready

How to do it...

How it works...

Setting up a system message

Getting ready

How to do it...

There's more...

Setting up a workspace announcement

Getting ready

How to do it...

There's more...

Setting up news items on the home page

Getting ready

How to do it...

There's more...

Creating a site-specific task list

Getting ready

How to do it...

How it works…

Creating a public theme

Getting ready

How to do it...

How it works...

There's more...

Locking a workspace

Getting ready

How to do it...

How it works...

There's more...

Creating table APIs

Getting ready

How to do it...

How it works...

There's more…

12. Team Development

Introduction

Creating a list of features

Getting ready

How to do it...

There's more...

Creating and assigning To-dos

Getting ready

How to do it...

Keeping track of bugs in the Bugtracker

Getting ready

How to do it...

There's more…

Creating Milestones

Getting ready

How to do it...

Using Feedback

Getting ready

How to do it...

There's more...

Using follow-ups

Getting ready

How to do it…

How it works...

13. HTML5 and CSS3

Introduction

Using a responsive HTML5 and CSS3 template

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a form with HTML5 item types

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a UI with drag-and-drop

Getting ready

How to do it...

How it works...

Creating storage events

Getting ready

How to do it...

How it works...

Geolocation – creating a tracker

Getting ready

How to do it...

How it works...

Creating a video plug-in

Getting ready

How to do it...

How it works...

Creating HTML5 charts

Getting ready

How to do it...

How it works...

14. Mobile

Introduction

Creating a smartphone application

Getting ready

How to do it...

How it works...

There's more...

See also

Creating a hybrid application

How to do it...

How it works...

Creating a list view report

Getting ready

How to do it...

How it works...

There's more...

Creating a mobile form

Getting ready

How to do it...

There's more...

See also

Using mobile item types

Getting ready

How to do it...

There's more...

See also

Creating a mobile calendar

Getting ready

How to do it...

How it works...

There's more...

Creating a date scroller with the Mobiscroll plug-in

Getting ready

How to do it...

How it works…

There's more...

Uploading images using the camera on the device

Getting ready

How to do it...

How it works...

There's more...

Using jQuery Mobile to fetch current GPS location

Getting ready

How to do it...

How it works...

See also

Creating swipe events

Getting ready

How to do it...

How it works…

There's more...

Index