Understanding Oracle APEX 5 Application Development, Second Edition

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