1/78

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 5.1
  • New Features
  • Deprecated and Desupported Features
  • Other Changes

1 About Oracle Application Express

• 1.1 Browser Requirements
• 1.2 About Oracle Application Express
• 1.3 About Database Applications
• 1.4 About Websheet Applications

2 Using Interactive Grids

• 2.1 About Interactive Grids
• 2.2 Accessing Interactive Grids
  • 2.2.1 About Interactive Grid URLs
  • 2.2.2 Accessing an Interactive Grid
• 2.3 Using an Interactive Grid
  • 2.3.1 Searching in an Interactive Grid
    • 2.3.1.1 About the Search Bar
    • 2.3.1.2 Using the Select Columns To Search Icon
  • 2.3.2 Rearranging Columns Using Drag and Drop
  • 2.3.3 Resizing Columns in an Interactive Grid
  • 2.3.4 Sorting Columns in an Interactive Grid
  • 2.3.5 Customizing an Interactive Grid with the Column Heading Menu
    • 2.3.5.1 About the Column Heading Menu in an Interactive Grid
    • 2.3.5.2 Displaying the Column Heading Menu
    • 2.3.5.3 Creating a Control Break in an Interactive Grid
    • 2.3.5.4 Creating an Aggregation with the Column Heading Menu
    • 2.3.5.5 Freezing Columns in Place
    • 2.3.5.6 Hiding Columns in an Interactive Grid
    • 2.3.5.7 Unhiding Columns in an Interactive Grid
    • 2.3.5.8 Filtering with the Column Heading Menu
  • 2.3.6 Customizing an Interactive Grid with the Actions Menu
    • 2.3.6.1 About the Actions Menu in an Interactive Grid
    • 2.3.6.2 Changing the Column Display in an Interactive Grid
    • 2.3.6.3 Filtering an Interactive Grid
      • 2.3.6.3.1 About Filters in Interactive Grids
      • 2.3.6.3.2 Creating a Row Filter in an Interactive Grid
      • 2.3.6.3.3 Creating a Column Filter in an Interactive Grid
      • 2.3.6.3.4 Editing a Filter in an Interactive Grid
      • 2.3.6.3.5 Disabling a Filter in an Interactive Grid
      • 2.3.6.3.6 Removing a Filter from an Interactive Grid
    • 2.3.6.4 Selecting Column Sort Order in an Interactive Grid
    • 2.3.6.5 Defining an Aggregation in an Interactive Grid
      • 2.3.6.5.1 Creating an Aggregation in an Interactive Grid
      • 2.3.6.5.2 Editing an Aggregation in an Interactive Grid
      • 2.3.6.5.3 Removing an Aggregation in an Interactive Grid
    • 2.3.6.6 Adding Highlighting to an Interactive Grid
    • 2.3.6.7 Creating a Control Break from the Actions Menu in an Interactive Grid
  • 2.3.7 Using Charts in an Interactive Grid
  • 2.3.8 Editing an Editable Interactive Grid
    • 2.3.8.1 About Editable Interactive Grids
    • 2.3.8.2 Adding a Row in an Editable Interactive Grid
    • 2.3.8.3 Editing Rows in an Interactive Grid
      • 2.3.8.3.1 About the Row Actions Menu in an Editable Interactive Grid
      • 2.3.8.3.2 About the Edit Button in an Interactive Grid
      • 2.3.8.3.3 Editing a Cell in an Interactive Grid
      • 2.3.8.3.4 Editing Multiple Rows in an Editable Interactive Grid
    • 2.3.8.4 Deleting a Row in an Interactive Grid
• 2.4 Saving Interactive Grids
  • 2.4.1 About Interactive Grid Report Types
  • 2.4.2 Saving a Report in an Interactive Grid
  • 2.4.3 Renaming a Report in an Interactive Grid
  • 2.4.4 Deleting a Report in an Interactive Grid
• 2.5 Resetting Interactive Grids
  • 2.5.1 Refreshing an Interactive Grid
  • 2.5.2 Resetting an Interactive Grid
  • 2.5.3 How the Reset Button Affects Saved Interactive Grid Reports
  • 2.5.4 Reverting an Interactive Grid to a Previous State
• 2.6 Downloading or Emailing an Interactive Grid

3 Using Interactive Reports

• 3.1 About Interactive Reports
• 3.2 Accessing Interactive Reports
  • 3.2.1 About Interactive Report URLs
  • 3.2.2 Accessing an Interactive Report
• 3.3 Using the Search Bar
• 3.4 Using the Select Columns To Search Icon
• 3.5 Using the Column Heading Menu
• 3.6 Using Interactive Report Filters
• 3.7 Customizing an Interactive Report Using the Actions Menu
  • 3.7.1 About the Actions Menu
  • 3.7.2 Selecting Columns to Display
  • 3.7.3 Adding a Filter
    • 3.7.3.1 About Creating Filters
    • 3.7.3.2 Adding, Editing, and Removing a Column Filter
    • 3.7.3.3 Adding, Editing, and Removing a Row Filter
  • 3.7.4 Selecting Column Sort Order
  • 3.7.5 Creating a Control Break
  • 3.7.6 Adding Highlighting
  • 3.7.7 Computing Columns
    • 3.7.7.1 Creating a Computation
    • 3.7.7.2 Deleting a Computation
  • 3.7.8 Defining an Aggregation Against a Column
    • 3.7.8.1 Creating an Aggregation Against a Column
    • 3.7.8.2 Removing a Column Aggregation
  • 3.7.9 Creating a Chart from the Actions Menu
    • 3.7.9.1 Creating a Chart
    • 3.7.9.2 Editing a Chart
    • 3.7.9.3 Deleting a Chart
  • 3.7.10 Grouping Columns
    • 3.7.10.1 Creating a Group By
    • 3.7.10.2 Editing a Group By
    • 3.7.10.3 Selecting a Group By Sort Order
    • 3.7.10.4 Deleting a Group By
  • 3.7.11 Managing Pivot Reports
    • 3.7.11.1 Creating a Pivot Report
    • 3.7.11.2 Editing a Pivot Report
    • 3.7.11.3 Deleting a Pivot Report
  • 3.7.12 Executing a Flashback Query
    • 3.7.12.1 Creating a Flashback Query
    • 3.7.12.2 Editing a Flashback Query
    • 3.7.12.3 Deleting a Flashback Query
  • 3.7.13 Saving an Interactive Report
    • 3.7.13.1 About the Report List
    • 3.7.13.2 About Configuration Dependencies
    • 3.7.13.3 Saving a Public or Private Interactive Report
    • 3.7.13.4 Renaming a Public or Private Interactive Report
    • 3.7.13.5 Deleting a Public or Private Interactive Report
  • 3.7.14 Resetting a Report
  • 3.7.15 Downloading a Report
  • 3.7.16 Subscribing to Report Updates by Email
    • 3.7.16.1 How Report Subscriptions Work
    • 3.7.16.2 Subscribing to Updated Report Results

4 Data Loading Wizard Examples

• 4.1 About Using the Data Loading Wizard
• 4.2 Importing Data from a File into Your Application
• 4.3 Copying and Pasting Data into Your Application

5 Using Websheets

• 5.1 About Websheet Applications
• 5.2 Accessing Websheets
  • 5.2.1 About Websheet URLs
  • 5.2.2 Accessing a Websheet
• 5.3 Using Websheets
  • 5.3.1 Breadcrumb Sections
  • 5.3.2 Navigation Sections
  • 5.3.3 Showing and Hiding Page Sections
  • 5.3.4 Online Help
  • 5.3.5 Signing out of a Websheet
  • 5.3.6 About the Websheet Search Bar
  • 5.3.7 Control Panel
• 5.4 Managing Websheet Pages
  • 5.4.1 Adding a New Page
  • 5.4.2 Copying an Existing Page
  • 5.4.3 Editing Page Details
• 5.5 Adding and Editing Page Sections
  • 5.5.1 About Page Section Types
  • 5.5.2 Editing Page Sections
  • 5.5.3 Deleting Page Sections
  • 5.5.4 Editing Section Titles and Display Order
• 5.6 Adding and Editing Text Sections
  • 5.6.1 Adding a Text Section
  • 5.6.2 Editing a Text Section
• 5.7 Adding a Navigation Section
• 5.8 Managing Data Grids
  • 5.8.1 About Data Grids
  • 5.8.2 Creating a Data Grid
    • 5.8.2.1 Creating a Data Grid from Scratch
    • 5.8.2.2 Creating a Data Grid by Copying and Pasting Spreadsheet Data
  • 5.8.3 Copying a Data Grid
  • 5.8.4 Viewing and Editing a Data Grid
    • 5.8.4.1 Accessing the Data Page
    • 5.8.4.2 Toggling Check Boxes
    • 5.8.4.3 Editing Data Grid Data
    • 5.8.4.4 Editing Data Grid Columns Manually
    • 5.8.4.5 Editing Data Grid Rows Manually
    • 5.8.4.6 Editing a Single Data Grid Row
    • 5.8.4.7 Adding Annotations to a Single Data Grid Row
    • 5.8.4.8 Displaying Annotation Columns in a Data Grid Report
    • 5.8.4.9 Displaying Pseudo Columns in a Data Grid Report
    • 5.8.4.10 Editing Data Grid Properties
    • 5.8.4.11 Creating a Bookmark Link to a Data Grid
  • 5.8.5 Viewing the Data Grid Change History Log
  • 5.8.6 Deleting a Data Grid
• 5.9 Adding and Editing Data Content
  • 5.9.1 About Available Data Sources
  • 5.9.2 Enabling Support for Creating Data Reports
  • 5.9.3 About Incorporating Data into Websheet Pages
• 5.10 Adding Data Reports
  • 5.10.1 About Data Reports
  • 5.10.2 Creating a Data Report
  • 5.10.3 Viewing and Modifying a Data Report
  • 5.10.4 Deleting a Data Report
• 5.11 Creating Data Sections Based on a Data Grid or Report
  • 5.11.1 Adding a Data Section to a Page
  • 5.11.2 Editing a Data Section
• 5.12 Creating Chart Sections
  • 5.12.1 Adding a Chart Section
  • 5.12.2 Editing a Chart Section
• 5.13 Understanding Markup Syntax
  • 5.13.1 Linking to a Page
  • 5.13.2 Linking to a Section
  • 5.13.3 Linking to External URLs
  • 5.13.4 Linking to a Data Grid
  • 5.13.5 Using SQL and SQLVALUE Syntax
  • 5.13.6 Advanced Data Grid Queries Rules
• 5.14 Managing Annotations
  • 5.14.1 Managing Uploaded Files and Images
    • 5.14.1.1 Uploading Files and Images
    • 5.14.1.2 Including a Download Link in a Page Section
    • 5.14.1.3 Displaying an Uploaded Image Inline
    • 5.14.1.4 Editing or Deleting Uploaded Files
  • 5.14.2 Adding Tags
    • 5.14.2.1 Adding Tags
    • 5.14.2.2 Editing Existing Tags
    • 5.14.2.3 Deleting Existing Tags
  • 5.14.3 Adding Notes
    • 5.14.3.1 Adding Notes
    • 5.14.3.2 Editing or Deleting Existing Notes
  • 5.14.4 Viewing and Deleting Annotations
    • 5.14.4.1 Accessing the Annotations Page
    • 5.14.4.2 Deleting Annotations
• 5.15 Managing Websheet Applications
  • 5.15.1 Changing Your Websheet Password
  • 5.15.2 Emailing a Websheet Page
  • 5.15.3 Printing a Websheet Page
• 5.16 Viewing Websheets
  • 5.16.1 About Presentation Mode
  • 5.16.2 Viewing the Page Directory
  • 5.16.3 Viewing Page History
  • 5.16.4 Viewing the Websheet Directory

Index