Beginning Oracle application express 4.2 / Doug Gault ... [et. al.].

Format:

Book

Author/Creator:

Gault, Doug.

Series:

Expert's voice in Oracle.

The expert's voice in Oracle Beginning Oracle Application express 4.2

Language:

English

Subjects (All):

Oracle (Computer file).

Application software.

Physical Description:

1 online resource (xxiii, 422 pages) : illustrations (chiefly color).

Edition:

2nd ed. 2013.

Place of Publication:

Berkeley, CA : Apress, 2013.

Language Note:

English

System Details:

text file

Summary:

Beginning Oracle Application Express 4.2 introduces version 4.2 of the popular and productive Oracle Application Express development platform. Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 4.2 brings extensive new Flash and HTML 5 charting capabilities, enhanced themes for mobile applications usable from phones and tablets, RESTful web services support, enhanced application packaging, and the many redesigned wizards give a new and fresh feel to the user interface. Whether you’re new to Oracle or an old hand who’s yet to test the waters of APEX, Beginning Oracle Application Express 4.2 introduces the processes and best practices you’ll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. All code is documented and explained so that those new to the languages will not be lost. After reading this book, power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company. Covers brand-new functionality in APEX 4.2 Provides fully documented and explained example code Guides you through creating a working and fully deployable application.

Contents:

Cover

Title Page

Copyright Page

Dedication Page

Contents at a Glance

Table of Contents

About the Authors

About the Technical Reviewer

Acknowledgements

CHAPTER 1 An Introduction to APEX 4.2

What Is APEX?

A Brief History of APEX

Ancient History

More Recent History

APEX 4 and the Future

What You Need to Get Started

Access to an APEX Instance

Web Browser

SQL Developer

Summary

CHAPTER 2 A Developer's Overview

The Anatomy of a Workspace

APEX Users

Applications, Pages, Regions, and Items

Workspaces, Applications, and Schemas

A Final Word on Workspaces

A Tour of the APEX Modules

The Home Page

Application Builder

The Application Builder Home Page

The Application Home Page

SQL Workshop

The Object Browser

The SQL Commands Interface

SQL Scripts Interface

The Query Builder

Utilities

Administration and Team Development

CHAPTER 3 Identifying the Problem and Designing the Solution

Identifying System Requirements

Never a Clean Slate

A Broken System

How Do You Fix Things?

Defining the Requirements

Extrapolating to a Database Design

System Design with APEX in Mind

Table Definition and User Interface Defaults

APEX and Primary Keys

Business Logic vs. User Interface Logic

Placement of Database Objects

Translating Theory to Practice

CHAPTER 4 SQL Workshop

Creating Objects with the Object Browser

Loading Data with the Data Workshop Utility

Creating a Lookup Table

Loading and Running SQL Scripts

User Interface Defaults

Understanding User Interface Defaults

Defining UI Defaults for Tables

CHAPTER 5 Applications and Navigation

The Create Application Wizard

Sample and Packaged Applications

Websheet Applications

Database Applications from Spreadsheets

Database Applications from Scratch

Naming the Application

Laying Out Pages

Copying Shared Components

Application Attributes

Selecting an Authentication Method

Selecting Tab Options

Globalization Options

Selecting a Theme

Completing the Create Application Wizard

HTML Regions

Public Pages

Navigation Bar Entries

Global Pages

Breadcrumb Regions

Breadcrumb Entries

Lists

List Regions

Template Positions

Lists of Values

Static List of Values

Dynamic List of Values

CHAPTER 6 Forms and Reports-The Basics

APEX Forms

Form on a Table

Creating a Form on a Table

Modifying a Form on a Table

Changing the Label Templates

Making the Fields Mandatory

Looking Behind the Scenes

Form on a Procedure

Creating a Form on a Procedure

Modifying a Form on a Procedure.

Notes:

Includes index.

Includes bibliographical references and index.

ISBN:

9781430257356

1430257350

OCLC:

859779595