Pro Oracle Application Express 4 · 2nd Edition by Tim Fox, John Edward Scott, Scott Spendolini -- Read -- Imperial Library of Trantor

Index

Cover Title Copyright Dedication Contents at a Glance Contents About the Authors About the Technical Reviewer Acknowledgments Foreword Introduction Chapter 1: Development Best Practices

APEX Installation Decisions Application Development Considerations

Users and Administrators Workspaces and Schemas Application Deployment Application Portability and Code Reuse

Performance Considerations

Bind Variables Report Pagination Style Error and Exception Handling Packaged Code

Team Development

Using Team Development

New Development Features in APEX 4.0 Summary

Chapter 2: Authentication and User Management

Preconfigured Authentication Schemes Open Door Credentials No Authentication Application Express Account Credentials

Creating New Application Users Creating Groups Controlling Authentication with Groups Maintaining Cookie Users Within Your Application

Database Account Authentication Custom Authentication

Creating an Application from a Spreadsheet Creating the User Repository Creating a New Authentication Scheme Regarding Index Usage Hash Rather Than Crypt

Implementing Locked User Accounts

Understanding the Login Process Modifying the Notification Message A Note About Session Management

Automating User Registration

Modifying the User Repository Modifying the Authentication Method Creating a Registration Form Adding a Verification Link Table Adding a User Registration Procedure Adding the Procedure to Send the Verification Handling the Verification Link

Managing Session Timeouts Summary

Chapter 3: Conditions and Authorization Schemes

Specifying Condition Types

No Condition Exists (SQL Query Returns at Least One Row) NOT Exists (SQL Query Returns No Rows) SQL Expression PL/SQL Expression PL/SQL Function Body Returning a Boolean Request = Expression 1 Request != Expression 1 Request Is Contained Within Expression 1 Value of Item in Expression 1 = Expression 2 Value of Item in Expression 1 Is NULL Current Page = Expression 1 Current Page Is Contained Within Expression 1 (Comma Delimited List of Pages) User Is Authenticated (Not Public) User Is the Public User (User Has Not Authenticated) Current Language Is Contained Within Expression 1 Never

Using Conditions Appropriately Authorization Schemes

Creating an Authorization Scheme Protecting Your Resources To Cache or Not to Cache Resetting the Caching

Summary

Chapter 4: Data Security

URLs and Security

Understanding the URL Syntax Manipulating the URL

Session State Protection

Enabling Session State Protection Configuring Session State Protection

Virtual Private Database

Implementing VPD Using Contexts with VPD Using Advanced VPD Features VPD Best Practices

Auditing

Enabling Auditing Viewing Audit Data

Summary

Chapter 5: Navigation and Layout

Tabs

Understanding Tab States: Current and Noncurrent Using Standard Tabs Using Parent Tabs

Navigation Bars

Accessing Navigation Bar Entries Creating Navigation Bar Entries Performing an Action on the Current Page

Breadcrumbs

Accessing Breadcrumb Entries Using Dynamic Breadcrumb Entries Displaying Breadcrumbs

Lists

Accessing List Entries Creating a Menu Using a List Tracking Clicks on List Entries Using User-Defined Attributes for List Entries

Trees

Creating a Table for the Tree Entries Creating the Tree Component Enabling and Disabling Tree Entries

Page Zero

Creating Page Zero Adding Regions to Page Zero

Layout

Positioning Regions Positioning Page Items Drag-and-Drop Positioning

Summary

Chapter 6: Reports and Charts

Reports

Report Headers Named Columns vs. Generic Columns Report Pagination Break Formatting Column Formatting Columns as Links

Charts

Chart Query Types HTML Charts Flash Charts Generic Charting

Summary

Chapter 7: Dynamic Actions

Implementing a Dynamic Search Calling On Demand Processes

Understanding Your Choices

Showing and Hiding Page Elements

Showing and Hiding Fields Using Advanced Dynamic Actions Showing and Hiding Items Using Standard Dynamic Actions Ajax within APEX

Summary

Chapter 8: Websheets

Preparing for Websheet Development Building a Websheet Application Running a Websheet Application

Logging In Building a Data Grid Using the Buglist Websheet Contributing Content to a Websheet

Summary

Chapter 9: Reporting and Printing

Choosing a Print Server Configuring APEX to Use a Print Server Printing Reports

Enabling Printing for a Report Troubleshooting Print Problems Configuring Some Simple Print Options

Creating Custom Report Layouts with BI Publisher

Installing the Client-Side Layout Tool Creating a New Report Layout Adding Graphics and Charts

Generating Reports Through Apache FOP

Installing Apache FOP Creating a New Layout Using XSL-FO Adding Graphics to a Report

Summary

Chapter 10: Themes and Templates

Themes

Associating a Theme with an Application Viewing Theme Details and Reports Performing Theme Tasks Defining Theme Attributes Switching Themes

Templates

Removing Unused Templates Viewing Template Information Understanding Template Types and Classes Managing Template Files Choosing a Template Type

Template Subscriptions

Setting Up a Theme Subscription System Refreshing Subscriptions

Tools for Working with Templates Summary

Chapter 11: Localization Issues

Localizing Application Builder

Choosing a Language Installing a Language File

Localizing Your Applications

A Simple Currency Example User-Dependent Localization NLS Parameters

Fully Translating Your Applications

Defining the Primary Application Language and Derived From Language Creating Translated Versions of an Application Translating On the Fly Translating the Standard Messages

Summary

Chapter 12: Plug-ins

Creating Your First Plug-in

Running the APEX Plug-in Builder Using Your New Plug-in Using Custom Attributes

Exporting Plug-ins Importing Plug-ins Summary

Chapter 13: Web Services

Creating a Native Database Web Service Creating a WSDL-based Web Service Reference in APEX Creating a RESTful Web Service Invoking an External Service Summary

Chapter 14: Performance and Scalability

Diagnosing Performance Problems

Viewing Application Reports Using Debug Mode Using SQL Tracing and TKProf Giving Timing Information to the Users

Making Your Applications More Scalable

Image Caching Revisited Page and Region Caching HTTP Compression

Summary

Chapter 15: Production Issues

Managing URLs

Using a Location Redirect Using Frames Using Apache mod_rewrite Proxying Requests

Backing Up Applications

Manual Exports Easy Backups the Database Way Automated Backups “As of” Backups

Migrating Between Environments

Upgrading Applications Cloning an Application

Summary

Chapter 16: APEX Dictionary

Accessing the APEX Dictionary

Using the Application Builder Interface Using the apex_dictionary View

Uses for the APEX Dictionary

Quality Assurance Self-Documentation Automated Monitoring

Using the API

Adding Items to Your Pages Creating Text Fields Programmatically Generating Applications A Final Warning!

Summary

Index

← Prev
Back
Next →

← Prev
Back
Next →