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

Understanding Oracle APEX 5 Application Development, Second Edition

Book Description

This new edition of Understanding Oracle APEX 5 Application Development shows APEX developers how to build practical, non-trivial web applications. The book introduces the world of APEX properties, explaining the functionality supported by each page component as well as the techniques developers use to achieve that functionality. The book is targeted at those who are new to APEX and just beginning to develop real projects for production deployment.

Reading the book and working the examples will leave you in a good position to build good-looking, highly-functional, web applications. Topics include: conditional formatting, user-customized reports, data entry forms, concurrency and lost updates, and updatable reports. Accompanying the book is a demo web application that illustrates each concept mentioned in the book. Specific attention is given in the book to the thought process involved in choosing and assembling APEX components and features to deliver a specific result. Understanding Oracle APEX 5 Application Development is the ideal book to take you from an understanding of the individual pieces of APEX to an understanding of how those pieces are assembled into polished applications.

  • Teaches how to develop non-trivial APEX applications.
  • Provides deep understanding of APEX functionality.
  • Shows the techniques needed for customization.
  • Table of Contents

    1. Cover
    2. Title
    3. Copyright
    4. Contents at a Glance
    5. About IOUG Press
    6. Contents
    7. About the Author
    8. About the Technical Reviewer
    9. Acknowledgments
    10. Introduction
    11. Chapter 1: The SQL Workshop
      1. Object Browser
      2. SQL Command Tool
      3. Summary
    12. Chapter 2: Applications and Pages
      1. Creating an Application
      2. Editing Application Properties
      3. Deleting an Application
      4. Running an Application Page
        1. Running a Page from within APEX
        2. Running a Page from Outside of APEX
      5. Creating a New Page
      6. Page Designer
      7. Property Editor
      8. Accessing Built-in Help
      9. Summary
    13. Chapter 3: Regions
      1. Creating and Deleting Regions
      2. Type-Independent Region Properties
        1. Identification and Source Sections
        2. Layout Section
        3. Grid Section
        4. Appearance Section
      3. Drag and Drop
      4. Static Content Regions
        1. Formatted vs. Unformatted Text
        2. Substitution Strings
        3. Referring to APEX pages
        4. Referring to Local Images
      5. Classic Report Regions
        1. Column-Specific Properties
        2. Report-Specific Properties
        3. Using the Source Query for Formatting
      6. Chart Regions
        1. Creating a Chart Region
        2. A Chart’s Source Query
        3. Chart-Specific Properties
        4. Series-Specific Properties
      7. Interactive Report Regions
        1. Using the Search Bar
        2. Configuring the Search Bar
        3. Link Column
      8. Summary
    14. Chapter 4: Navigation
      1. ListsLists
        1. Viewing List Details
        2. Editing List Entries
        3. Creating New List Entries
        4. Creating a New List
      2. Modifying the Navigation Interface
        1. Configuring the Navigation Menu
        2. Configuring the Navigation Bar
      3. List Regions
      4. Hierarchical Lists
      5. Page Hierarchy
      6. Breadcrumbs
      7. Breadcrumb Regions
      8. Global Page
      9. Summary
    15. Chapter 5: Items and Buttons
      1. Items
      2. Item Sampler Page
      3. Creating and Deleting Items
      4. Positioning an Item
      5. Text-Based Items
        1. Text Fields
        2. Number Fields
        3. Password Items
        4. Text Fields with Autocomplete
        5. Color Pickers
        6. Date Pickers
      6. List-Based Items
        1. Dynamic List–Based Items
        2. Static List–Based Items
        3. Properties for List–Based Items
      7. Multi-Value List Items
      8. Yes/No Items
      9. Display-Based Items
      10. Initial Item Values
      11. ButtonsItems
      12. Summary
    16. Chapter 6: Session State
      1. Session IDs
      2. Submit vs. Redirect
      3. Using an Item to Submit a Page
      4. Setting Session State During a Redirect
      5. Referring to a Session State Variable
      6. Customized ReportsCustomized reports
        1. Filter by Job and Department Page
        2. Filter by Possible Department Page
        3. Filter by Salary Range Page
      7. Master-Detail Reports
      8. Chart Drill-Down
      9. Customized Titles and Labels
      10. Cascading Lists
      11. Conditional Rendering
      12. Region Display Selectors
      13. Summary
    17. Chapter 7: Processes
      1. Stages of a Submit Action
      2. PL/SQL Processes
      3. PL/SQL to Access the Database
        1. Delete Employee Region
        2. Insert Employee Region
        3. Update Employee Region
      4. PL/SQL to Compute Values
        1. Local Variables
        2. Comments
        3. Assignment Statements
        4. Conditional Statements
      5. Handling Multi-Row SQL Queries
      6. Concurrent Database Updates
        1. Lost Update Problem
        2. Transactions
        3. Avoiding Lost Updates
        4. Using a Hash Function
      7. Success and Error Messages
      8. Conditional Processes
      9. Page Rendering ProcessesPage rendering processes
        1. Executing a Process Without a Submit
        2. Report Mode vs. Single-Record Mode
        3. Implementing Previous and Next Buttons
      10. Report Data Entry
        1. Implementing the Report Region
        2. Implementing the Insert Region
        3. Implementing the Update/Delete Region
      11. APEX Built-In Processes
        1. Automatic Row Fetch
        2. Automatic Row Processing
        3. Clear Session State
        4. Form Pagination
      12. Using the Built-In Processes
        1. Employee Data Entry
        2. Sales Commissions
        3. Single Record View
        4. Report Data Entry
      13. APEX Built-in Form Pages
        1. Form on a Table or View
        2. Form on Table with Report
        3. Master-Detail Form
      14. Summary
    18. Chapter 8: Data Validation
      1. Constraint Preservation
      2. Input Validation
      3. Process Validation
      4. Summary
    19. Chapter 9: Branches
      1. Separating Input from Output
      2. Creating a Branch
      3. Conditional Branching
      4. Wizard-Like InterfacesWizard-like interfaces
        1. Implementing the Progress Bar
        2. Basic Info Page
        3. Manager Info Page
        4. Hiredate Info Page
        5. Confirm Employee Info Page
      5. Summary
    20. Chapter 10: Tabular Forms
      1. Creating a Tabular Form Region
      2. Accessing Values from a Tabular Form
      3. Updating the Database
      4. Validations
      5. Built-in Tabular Form Processes
      6. Tabular Form Wizard
      7. Summary
    21. Chapter 11: Dynamic SQL
      1. Dynamic Reports
      2. Dynamic Processes
      3. Combining Dynamic Reports and Processes
      4. Summary
    22. Chapter 12: Security
      1. Authentication
        1. Managing Authentication Schemes
        2. Writing an Authentication Function
        3. Public Pages
      2. Authorization
        1. Creating an Authorization Scheme
        2. Component Authorization
        3. Page Authorization
        4. Not Public User Scheme
      3. Avoiding Malicious Use
        1. SQL Injection
        2. Cross-Site Scripting
        3. URL Modification
      4. Summary
    23. Index
    24. General