Oracle APEX cookbook / Marcel van der Plas, Michel van Zoest.

Format:

Book

Author/Creator:

Plas, Marcel van der.

Contributor:

Zoest, Michel van.

Language:

English

Subjects (All):

Oracle Application express.

Application software--Development.

Application software.

Internet programming.

Physical Description:

1 online resource (1 v.) : ill.

Edition:

2nd ed.

Place of Publication:

Birmingham, UK : Packt Pub., 2013.

Summary:

As a Cookbook, this book enables you to create APEX web applications and to implement features with immediately usable recipes that unleash the powerful functionality of Oracle APEX 4.2. Each recipe is presented as a separate, standalone entity and the reading of other, prior recipes is not required.It can be seen as a reference and a practical guide to APEX development.This book is aimed both at developers new to the APEX environment and at intermediate developers. More advanced developers will also gain from the information at hand.If you are new to APEX you will find recipes to start development and if you are an experienced user you will find ways to improve your productivity and efficiency and make the most of APEX to enhance your applications.A little knowledge of PL/SQL, HTML and JavaScript is assumed.

Contents:

Intro

Oracle APEX Cookbook Second Edition

Table of Contents

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

There's more…

Creating a simple report

See also

Implementing an interactive report

There's more...

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.

Getting ready

Putting some validation in a form

Creating a report with PL/SQL Dynamic Content

2. Themes and Templates

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

3. Extending APEX

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

There's more.

Calling APEX from an Oracle Form

Creating a data upload page

Using shipped files

4. Creating Websheet Applications

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

5. APEX Plug-ins

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

How to do it…

6. Creating Multilingual APEX Applications

Creating a translatable application

Using XLIFF files

Switching languages

Translating data in an application

7. APEX APIs

Updating a table with the hidden primary key

How to do it.

How it works...

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

8. Using Web Services

Creating a SOAP web service reference

Creating a REST web service reference

How it works…

Building a page on a web service reference

Publishing a RESTful web service

9. Publishing from APEX

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

10. APEX Environment

Setting up a development environment using subscriptions

Debugging an APEX application

Getting ready.

How to do it...

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

Using packaged applications

11. APEX Administration

Creating a workspace manually

Creating a workspace by request

Creating a user

Adding a schema to your workspace

Setting up a system message

Setting up a workspace announcement

Setting up news items on the home page

Creating a site-specific task list

Creating a public theme

Locking a workspace

Creating table APIs

12. Team Development

Creating a list of features

Creating and assigning To-dos

Keeping track of bugs in the Bugtracker.

Notes:

"Create reliable, modern web applications for desktop and mobile devices with Oracle Application Express"--Cover.

Includes index.

Description based on online resource; title from resource description page (Safari, viewed Dec. 30, 2013).

OCLC:

868297715