Table of Contents
- Title and Copyright Information
- Preface
- Changes in This Release
- 1 About Oracle Application Express
-
2
Using Interactive Grids
- 2.1 About Interactive Grids
- 2.2 About Editable Interactive Grids
- 2.3 Accessing Interactive Grids
- 2.4 Using an Interactive Grid
-
2.5
Customizing an Interactive Grid with the Actions Menu
- 2.5.1 Changing the Column Display in an Interactive Grid
-
2.5.2
Filtering an Interactive Grid
- 2.5.2.1 About Filters in Interactive Grids
- 2.5.2.2 Creating a Row Filter in an Interactive Grid
- 2.5.2.3 Creating a Column Filter in an Interactive Grid
- 2.5.2.4 Editing a Filter in an Interactive Grid
- 2.5.2.5 Disabling a Filter in an Interactive Grid
- 2.5.2.6 Removing a Filter from an Interactive Grid
- 2.5.3 Selecting Column Sort Order in an Interactive Grid
- 2.5.4 Defining an Aggregation in an Interactive Grid
- 2.5.5 Creating a Control Break from the Actions Menu in an Interactive Grid
- 2.5.6 Adding Highlighting to an Interactive Grid
-
2.6
Customizing an Interactive Grid with the Column Heading Menu
- 2.6.1 About the Column Heading Menu in an Interactive Grid
- 2.6.2 Displaying the Column Heading Menu
- 2.6.3 Creating a Control Break in an Interactive Grid
- 2.6.4 Creating an Aggregation with the Column Heading Menu
- 2.6.5 Freezing Columns in Place
- 2.6.6 Hiding Columns in an Interactive Grid
- 2.6.7 Unhiding Columns in an Interactive Grid
- 2.6.8 Filtering with the Column Heading Menu
-
2.7
Using an Editable Interactive Grid
- 2.7.1 Adding a Row in an Editable Interactive Grid
- 2.7.2 Editing Rows in an Interactive Grid
- 2.7.3 Deleting a Row in an Interactive Grid
-
2.7.4
Modifying Multiple Rows and Cells in an Editable Interactive Grid
- 2.7.4.1 About Selection Modes in an Editable Interactive Grid
- 2.7.4.2 Changing Selection Mode in an Editable Interactive Grid
- 2.7.4.3 Copying to Multiple Rows in an Editable Interactive Grid
- 2.7.4.4 Copying to Multiple Cells in an Editable Interactive Grid
- 2.7.4.5 Filling Cells in an Editable Interactive Grid
- 2.7.4.6 Clearing Cells in an Interactive Grid
- 2.8 Saving Interactive Grids
- 2.9 Resetting Interactive Grids
- 2.10 Downloading or Emailing an Interactive Grid
-
3
Using Interactive Reports
- 3.1 About Interactive Reports
- 3.2 Accessing Interactive Reports
- 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.4 Selecting Column Sort Order
- 3.7.5 Creating a Control Break
- 3.7.6 Adding Highlighting
- 3.7.7 Computing Columns
- 3.7.8 Defining an Aggregation Against a Column
- 3.7.9 Creating a Chart from the Actions Menu
- 3.7.10 Grouping Columns
- 3.7.11 Managing Pivot Reports
- 3.7.12 Executing a Flashback Query
- 3.7.13 Saving an Interactive Report
- 3.7.14 Resetting a Report
- 3.7.15 Downloading a Report
- 3.7.16 Subscribing to Report Updates by Email
- 4 Data Loading Wizard Examples
-
5
Using Websheets
- 5.1 About Websheet Applications
- 5.2 Accessing Websheets
- 5.3 Using Websheets
- 5.4 Managing Websheet Pages
- 5.5 Adding and Editing Page Sections
- 5.6 Adding and Editing Text Sections
- 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.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.10 Adding Data Reports
- 5.11 Creating Data Sections Based on a Data Grid or Report
- 5.12 Creating Chart Sections
- 5.13 Understanding Markup Syntax
- 5.14 Managing Annotations
- 5.15 Managing Websheet Applications
- 5.16 Viewing Websheets
- Index