O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle Application Express: Build Powerful Data-Centric Web Apps with APEX

Book Description

This Oracle Press guide shows how to build and deploy powerful Web applications with Oracle Application Express and features full coverage of the latest version, APEX 5.0

This comprehensive volume from Oracle Press offers up-to-date coverage of Oracle Application Express (APEX), Oracle’s rapid development tool for the Web developer. APEX is an entirely Web-based framework that comes built into every edition of Oracle Database—its backbone is Oracle’s powerful PL/SQL language, alongside the most advanced Web development technologies like HTML5, mobile development, and full support of CSS and JavaScript. APEX enables anyone—from novice user to seasoned developer—to easily create Web applications that are powerful, reliable, and highly scalable.

Oracle Application Express: Build Powerful Data‐Centric Web Apps lays out basic information about APEX concepts before delving into the unparalleled power of the platform and describing the new features in version 5.0. You will discover how to install and configure APEX, work with the Application Builder and Page Designer, use built-in wizards, and design custom Web apps.

  • Teaches the cleanest and fastest builds for high-performance, secure web applications
  • Shows how to effectively migrate legacy applications into a modern Web-based environment
  • Authored by early adopters of APEX 5.0 who have been active in the APEX community for years

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. Contents
  6. Acknowledgments
  7. Introduction
  8. 1 Introduction to Oracle Application Express
    1. A Native Web Tool for Developing Web Applications
      1. Native to the Web World
      2. Client-Side Platform Independent
      3. Effortless Deployment to Clients
    2. A Declarative RAD IDE
    3. Oracle Database Data-Centric Applications Tool
      1. Oracle Database Tool
      2. Data-Centric Applications
    4. APEX Architecture
      1. The APEX Engine
      2. Everything in Between
    5. Installation, Configuration, and Upgrade
      1. The Installation Process
      2. APEX Upgrade
    6. Summary
  9. 2 Getting Ready
    1. Recommended Prerequisite Knowledge
      1. SQL and PL/SQL
      2. HTML/HTML5, CSS, and JavaScript
      3. jQuery
      4. Ajax
    2. Application Planning
      1. High Level Design
    3. Best Practice: Document Your Work
    4. The Book Demo Application: Contacts in the Cloud
      1. Application Business Logic and QA Scenarios
      2. Designing the Data Structures
      3. Data Modeling
    5. Summary
  10. 3 APEX IDE: Quick Tour and Basic Concepts
    1. Working with the APEX IDE
      1. Main Menu
      2. Developer Navigation Tools
      3. Other Elements on the Workspace Home Page
    2. Major Modules of the APEX IDE
      1. App Builder Module
      2. SQL Workshop Module
      3. Team Development Module
      4. Packaged Apps Module
      5. Instance Administration Module
    3. Summary
  11. 4 APEX Applications: Concepts and Building Blocks
    1. The APEX Instance
    2. The APEX Workspace
      1. Workspace Users
    3. APEX Applications
      1. Desktop Applications
      2. Mobile Applications
      3. Application-Level Features and Shared Components
      4. Websheet Applications
    4. APEX Themes (Concepts)
      1. APEX Themes: Evolution and Revolution
      2. APEX Templates
    5. APEX Pages
      1. APEX Page Types
      2. APEX Page Mode
    6. APEX Regions
    7. APEX Items
      1. APEX Application Items
      2. APEX Page Items
    8. APEX Buttons
      1. Button Properties
    9. Summary
  12. 5 The Page Designer
    1. Installing the Sample Database Application
    2. Navigating the New Page Designer
      1. The Toolbar
      2. The Three Panes
    3. Laying Out Items on a Page
      1. Layout Properties
    4. Keyboard Shortcuts
    5. Summary
  13. 6 APEX Wizards
    1. The Application Wizard
    2. The Report Region
    3. The Form Wizard
      1. Form Wizard Review
    4. Customizing a Report
      1. Testing the Report Link
      2. Creating a Button
    5. Creating a Contact Record
    6. Creating Interactive Reports
      1. Column Headings
      2. Reports Toolbar
      3. Behind the Interactive Report Properties
      4. Behind the Interactive Report Columns
    7. Interactive Grids
      1. Create an Interactive Grid
      2. The Interactive Grid Toolbar
      3. Row Actions Menu
      4. Edit and Save Buttons
      5. Other Features of Interactive Grids
      6. Editing Data with the Interactive Grid
      7. Interactive Grid Validations
      8. Advanced Interactive Grid Options
      9. Allowed Row Operations Column
    8. Master Detail Form and User Interface Defaults
      1. Creating a Master Detail Form
      2. User Interface Defaults for a Table
    9. Summary
  14. 7 Computations, Validations, Processes, and Branches
    1. Computations
      1. Computation Types
      2. Page Execution Points
      3. Creating a Computation
    2. Validations
      1. Item-Level Validation
      2. Page-Level Validation
      3. Interactive Grid Validations
    3. Processes
      1. Process Types
      2. Working with Processes
    4. Branches
      1. Branch Execution Points
      2. Branch Types
      3. Creating Branches
      4. Summary
  15. 8 Crafting a Powerful UI
    1. Themes and Templates
      1. User Interface Attributes
      2. Themes
      3. Templates
    2. Using the Universal Theme in Your Application
      1. Pages
      2. Regions
      3. Lists
      4. Reports
      5. Buttons
      6. Forms
      7. Calendars
    3. Theme Roller
    4. Live Template Options
    5. Summary
  16. 9 Dynamic Actions
    1. About Dynamic Actions
      1. Benefits of Dynamic Actions
      2. Getting Started
      3. Bind Events
      4. Actions
      5. Anatomy of a Dynamic Action
    2. Creating a Dynamic Action
      1. Simple Show/Hide
      2. Dynamic Actions Affecting Multiple Items
      3. Dynamic Actions Using PL/SQL
      4. Advanced Dynamic Actions—Putting It All Together
    3. Summary
  17. 10 APEX Security
    1. Application Attack Points
    2. Instance-Level Security
      1. Security Section
      2. HTTP Protocol Section
      3. Session Timeout Section
      4. Workspace Isolation Section
      5. Region and Web Service Excluded Domains Section
      6. Authentication Control Section
      7. Password Policy Section
      8. REST Administration Interface Section
    3. Workspace-Level Security
      1. Workspace Groups
      2. Managing Workspace Users
    4. Application-Level Security
      1. Application-Level Authentication and Authorization Sections
      2. Application Session
      3. Session State Protection Section
      4. Browser Security Section
    5. Page-Level Security
      1. Security Properties
      2. Advanced Properties
      3. Server Cache Properties
    6. Region and Item-Level Security
      1. Regions Properties
      2. Items Properties
    7. Conditional Statements
    8. Authentication Schemes
    9. Authorization Schemes
    10. Access Control
    11. Security in Action
      1. Authorization Schemes
      2. Session State Protection and Item Encryption
      3. Conditions
      4. Application Context and Views
    12. Security Reporting
    13. Summary
  18. 11 Packaging and Deployment
    1. Packaging Overview
      1. Packaged Applications
    2. Application Exports
      1. Copy Your Application in the Same Workspace
      2. Move to a New Workspace that Uses the Same or a Different Schema
    3. Application Import/Export Strategies
      1. Exporting Components
      2. Importing an Application or Component
    4. Summary
  19. Index