Table of Contents
- Title and Copyright Information
- Preface
- 1 Changes in Release 20.2 for Oracle Application Express End User’s Guide
- 2 About Oracle Application Express
-
3
Using Interactive Grids
- 3.1 About Interactive Grids
- 3.2 About Editable Interactive Grids
- 3.3 Using an Interactive Grid
-
3.4
Customizing an Interactive Grid with the Actions Menu
- 3.4.1 Changing the Column Display in an Interactive Grid
-
3.4.2
Filtering an Interactive Grid
- 3.4.2.1 About Filters in Interactive Grids
- 3.4.2.2 Creating a Row Filter in an Interactive Grid
- 3.4.2.3 Creating a Column Filter in an Interactive Grid
- 3.4.2.4 Editing a Filter in an Interactive Grid
- 3.4.2.5 Disabling a Filter in an Interactive Grid
- 3.4.2.6 Removing a Filter from an Interactive Grid
- 3.4.3 Selecting Column Sort Order in an Interactive Grid
- 3.4.4 Defining an Aggregation in an Interactive Grid
- 3.4.5 Creating a Control Break from the Actions Menu in an Interactive Grid
- 3.4.6 Adding Highlighting to an Interactive Grid
-
3.5
Customizing an Interactive Grid with the Column Heading Menu
- 3.5.1 About the Column Heading Menu in an Interactive Grid
- 3.5.2 Displaying the Column Heading Menu
- 3.5.3 Creating a Control Break in an Interactive Grid
- 3.5.4 Creating an Aggregation with the Column Heading Menu
- 3.5.5 Freezing Columns in Place
- 3.5.6 Hiding Columns in an Interactive Grid
- 3.5.7 Unhiding Columns in an Interactive Grid
- 3.5.8 Filtering with the Column Heading Menu
-
3.6
Using an Editable Interactive Grid
- 3.6.1 Adding a Row in an Editable Interactive Grid
- 3.6.2 Editing Rows in an Interactive Grid
- 3.6.3 Deleting a Row in an Interactive Grid
-
3.6.4
Modifying Multiple Rows and Cells in an Editable Interactive Grid
- 3.6.4.1 About Selection Modes in an Editable Interactive Grid
- 3.6.4.2 Changing Selection Mode in an Editable Interactive Grid
- 3.6.4.3 Copying to Multiple Rows in an Editable Interactive Grid
- 3.6.4.4 Copying to Multiple Cells in an Editable Interactive Grid
- 3.6.4.5 Filling Cells in an Editable Interactive Grid
- 3.6.4.6 Clearing Cells in an Interactive Grid
- 3.7 Saving Interactive Grids
- 3.8 Resetting Interactive Grids
- 3.9 Downloading or Emailing an Interactive Grid
-
4
Using Interactive Reports
- 4.1 About Interactive Reports
- 4.2 Using the Search Bar
- 4.3 Using the Select Columns To Search Icon
- 4.4 Using the Column Heading Menu
- 4.5 Using Interactive Report Filters
-
4.6
Customizing an Interactive Report Using the Actions Menu
- 4.6.1 About the Actions Menu
- 4.6.2 Selecting Columns to Display
- 4.6.3 Adding a Filter
- 4.6.4 Selecting Column Sort Order
- 4.6.5 Creating a Control Break
- 4.6.6 Adding Highlighting
- 4.6.7 Computing Columns
- 4.6.8 Defining an Aggregation Against a Column
- 4.6.9 Creating a Chart from the Actions Menu
- 4.6.10 Grouping Columns
- 4.6.11 Managing Pivot Reports
- 4.6.12 Executing a Flashback Query
- 4.6.13 Saving an Interactive Report
- 4.6.14 Resetting a Report
- 4.6.15 Downloading a Report
- 4.6.16 Subscribing to Report Updates by Email
- 5 Data Loading Wizard Examples
-
6
Using Websheets
- 6.1 About Websheet Applications
- 6.2 Accessing Websheets
- 6.3 Using Websheets
- 6.4 Managing Websheet Pages
- 6.5 Adding and Editing Page Sections
- 6.6 Adding and Editing Text Sections
- 6.7 Adding a Navigation Section
-
6.8
Managing Data Grids
- 6.8.1 About Data Grids
- 6.8.2 Creating a Data Grid
- 6.8.3 Copying a Data Grid
-
6.8.4
Viewing and Editing a Data Grid
- 6.8.4.1 Accessing the Data Page
- 6.8.4.2 Toggling Check Boxes
- 6.8.4.3 Editing Data Grid Data
- 6.8.4.4 Editing Data Grid Columns Manually
- 6.8.4.5 Editing Data Grid Rows Manually
- 6.8.4.6 Editing a Single Data Grid Row
- 6.8.4.7 Adding Annotations to a Single Data Grid Row
- 6.8.4.8 Displaying Annotation Columns in a Data Grid Report
- 6.8.4.9 Displaying Pseudo Columns in a Data Grid Report
- 6.8.4.10 Editing Data Grid Properties
- 6.8.4.11 Creating a Bookmark Link to a Data Grid
- 6.8.5 Viewing the Data Grid Change History Log
- 6.8.6 Deleting a Data Grid
- 6.9 Adding and Editing Data Content
- 6.10 Adding Data Reports
- 6.11 Creating Data Sections Based on a Data Grid or Report
- 6.12 Creating Chart Sections
- 6.13 Understanding Markup Syntax
- 6.14 Managing Annotations
- 6.15 Managing Websheet Applications
- 6.16 Viewing Websheets
- Index