Contents

Foreword

First-Edition Foreword

About the Authors

About the Technical Reviewers

image Chapter 1: Page Designer

Main Components

Navigation

Page Finder Icon

Lock Pages and Undo and Redo Icons

Create, Utilities, and Component View Icons

Component View

Rendering

Dynamic Actions

Processing

Page Shared Components

Grid Layout

Grid Layout

Messages

Page Search

Help

Property Editor

Show Common

Show All

Collapse All

Show All

Quick Pick, Go to Group, and Go to Component Icons

Code Editor

Shortcuts

Help Functionalities

Link to the APEX 5.0 Documentation

Link to the APEX 5.0 Forum at OTN

Link to the APEX Resources at OTN

Page Designer Help: Getting Started in Page Designer

About Page Designer

Other Options

Multiple Component Selection

Resizing Page Designer Areas

Page Designer Memory Function

Page Designer Toolbar Options

Summary

image Chapter 2: Oracle REST Data Services

ORDS Defined

ORDS Download and Setup

Running the Install

Database Users Used by ORDS

Configuring Multiple Databases

Configuration Files

Administration via SQL Developer

ORDS Development via SQL Developer

REST Enabling an Existing Table

Invoking the New REST Service

Creating a REST Web Service

Accessing Hidden Parameters

Accessing ORDS Web Services via APEX

Summary

image Chapter 3: Oracle APEX 5.0 Charts Inside Out

HTML5 Charts

Background

Creating a Chart

The Result

Page Designer vs. Component View

Understanding the Chart Region

Understanding the Chart Attributes

Adding Multiple Series and Combined Charts

Different Chart Types

Behind the Scenes

Debug and Performance

Upgrading Oracle APEX 3.x/4.x Flash and SVG Charts

Screen Reader Mode and Charts

Extending Charts

Customizing Charts by Using Custom XML

Customizing Charts by Using Custom XML, Dynamic Actions, and JavaScript

Creating Charts Manually

Drill-Down Charts, Dashboards, and Interactivity

Simple Dashboard with Submit

Simple Dashboard with JavaScript

Complex Dashboard with Actions

Building Charts with the AnyChart Plugin

Most Common Issues

Chart Not Rendering Correctly

Search for a Specific Feature

Charts in the Future

Chart Plugins

Sample Charts in Packaged Application

Inline Charts in Report

Resources

Summary

image Chapter 4: Tabular Forms

Changes in APEX 4.0

Changes in APEX 4.1/4.2

Changes in APEX 5.0

Constraints

Purpose of Tabular Forms

Tabular Forms Are Not Spreadsheets

Features in APEX 4

New Item Types

Declarative Validations

Other Features

Features in APEX 4.1/4.2

New Validation Types for Tabular Forms

New Variables Available for the Processing

Tabular Forms and Dynamic Actions

Custom Coding in Tabular Forms

Processing the Correct Rows

Data Integrity

Manual Tabular Forms

Tabular Forms and Collections

Interesting Techniques

Multiple Tabular Forms and Modal Pages

Adding Cascading Select Lists to a Tabular Form

Summary

image Chapter 5: Team Development

Milestones

The Basics

Extending Milestone Functionality

Features

The Basics

Extending the Features Functionality

To Do’s

The Basics

Extending the To-Do Functionality

Bugs

Feedback

Feedback Process

Enable Feedback

Exporting Feedback to Development

Importing Feedback into Development

Team Development Integration in the Page Designer

Processing Feedback

Exporting Response to Deployment

Importing Response into Deployment

Extending Feedback: Creating a Report

Extending Feedback: Feeding Back the Follow-Up

Further Enhancements

Summary

image Chapter 6: Globalization

Using the Builder in Other Languages

Translating Applications

Application Language Derived From

Mapping

CSV Encoding

Translating an Application

Manually Translate an Application

Translating Data in the Database

Dynamic Translations

Translating APEX Internal Text

The APEX_LANG API

Copying Translations to Other Environments

Export/Import the Primary Application with the Translations

Export/Import the Primary Application and the Translated Applications Separately

Export Only the Primary Application and the XLIFF

Localization

SINCE Format Mask

Numeric Formats

Time Zones and Territories

Switching Languages

Summary

image Chapter 7: Debugging

Principles of Code Instrumentation

Debugging Basics

Page Processing and Rendering

Enabling Debug

Debug Information

Benefits of Debug Mode

Graphs and Charts

Interactive Reports

APEX Debugging API

APEX_DEBUG

Programmatic Debugging

Instrumenting Your Own Code

The Data Behind Debugging

Tables and View

Examining the Debug Data

Using Debug Data for More Than Debugging

Debugging Dynamic Actions

Debugging Plugins

Summary

image Chapter 8: Dynamic Actions

Custom JavaScript vs. Dynamic Actions

Manual (Custom JavaScript) Method

Dynamic Action Method

Dynamic Actions in Detail

Identification

Execution Options

When

Advanced

Actions

Dynamic Actions in Action

Business Case

Setup

Create Department Employees Report

Refresh Department Employees Report

Highlight Row

Row Click

Emphasize Employee Change

Modal Window

Summary

image Chapter 9: Lifecycle Management

Challenges

Deploying Database Changes

Collaborative Development

Parallel Development

Enterprise APEX Development

The Demo Project

Extending the APEX Development and Deployment Process

APEX Application Packaging

Apache Maven

Liquibase

The Oracle APEX Maven Plugin

Deploying Static Files

Multi-environment Setup

Building with Maven to Multiple Environments

One Code Base to Rule Them All

Jenkins

Summary

image Chapter 10: Plugins

The APEX Plugin Architecture

Create/Edit Page for Plugins

PL/SQL APIs

Other Tools of the Trade

jQuery and jQuery UI

jQuery UI Widget Factory

Font Awesome

Building a Region Plugin

The Base Plugin

File Setup

Initial Grid Render

Adjusting the UI for APEX

Getting Set Up for Success

Bringing on the AJAX

Using User-Specified Queries

Enabling Frozen Columns

Securing the Plugin

Best Practices for Developing Plugins

Summary

image Chapter 11: jQuery with APEX

JavaScript and jQuery

Basics of jQuery

The jQuery Object

Selecting Elements

DOM Nodes and jQuery Objects

Determining and Testing Selectors

Basic Manipulations

Iterating Over a Selection of Elements

Advanced Uses of jQuery

Handling Events

Traversing the DOM

Chaining Functions

APEX JavaScript APIs

AJAX Calls and AJAX Callback Processes

jQuery Versions

apex.jQuery

Pitfalls

Resources

Summary

image Chapter 12: Map Integration

Geocoding

Coordinates

Web Services

What Are XML and JSON?

Processing XML/JSON Results

Oracle Web Services

Choosing a Geocoding Service

The Mapping API

Including the API Libraries

Creating a div to Hold the Map

Writing JavaScript to Render the Map

Adding Layers

Interacting with the Database

Showing Query Results on a Map

Spatial Math

SDO_GEOMETRY

SDO Metadata

Spatial Indexes

APEX_SPATIAL Package

Calculating Distance

Search Within Distance

Calculate Area

Third-Party Data

Summary

image Chapter 13: Themes and Templates

What Is a Template?

What Is a Theme?

Component Defaults

Region Defaults

Dialog Defaults

The Substitution Strings

Finding Substitution Strings in the Application

Theme Styles

The Theme Roller

Template Options

The Grid

Responsive Layout

Subregions

Theme Subscriptions

Summary

image Chapter 14: Report Printing

Introduction

Report Printing

APEX Standard Report Printing

Prerequisites

Standard Report Printing Configuration

FOP Processor in ORDS

External FOP Processor

Enable Network Services

APEX Standard Report Printing

Classic Report Printing

Column Width Settings

Interactive Report PDF Output

Report Queries and Report Layouts

Report Query

Report Layouts

XSL-FO 101

XSL-FO

The XML

FO Document Structure

Customized PDF Output for Interactive Reports

Advanced XSL-FO Examples

<xsl:value-of select=...> Conditional Formatting

<xsl:choose ...> Conditional Formatting

XSL-FO Editors

Debugging XSL-FO

Third-Party Report Printing Solutions

General Report Printing Solutions

The Future

Summary

image Chapter 15: Working with APEX Collections

When to Use APEX Collections

Session State Management: A Quick Overview

Session State–Managed Tables

Logically Walking Through a Web Shopping Cart Implementation

A Look Under the Covers

Private Collections Objects Inside the APEX Engine

Public Collections Objects Inside the APEX Engine

Getting Started with Collections

Initializing a Collection

Adding and Removing Data from Collections

Using the Collection Contents

Exploring Another Use Case

Expanding the Example

Setting Up the Example

Summary

Index

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset