1/9

Contents

Title and Copyright Information

Preface

• Topic Overview
• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 4.2

1 About Oracle Application Express

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

2 Using Websheets

• 2.1 Running a Websheet
• 2.2 About Using Websheets
  • 2.2.1 Using Breadcrumbs and Navigation Sections
  • 2.2.2 About Online Help
  • 2.2.3 About the Logout Link
  • 2.2.4 About Websheet Search
  • 2.2.5 About the Control Panel
• 2.3 Managing Websheet Pages
  • 2.3.1 Adding a New Page
  • 2.3.2 Copying an Existing Page
  • 2.3.3 Editing Page Details
• 2.4 About Adding and Editing Page Sections
  • 2.4.1 About Section Types
  • 2.4.2 About Editing Sections
  • 2.4.3 Deleting Page Sections
  • 2.4.4 Editing Section Titles and Display Order
• 2.5 About Text Sections
  • 2.5.1 Adding a Text Section
  • 2.5.2 Editing a Text Section
• 2.6 About Navigation Sections
  • 2.6.1 Adding a Navigation Section
• 2.7 About Adding Data Grids
  • 2.7.1 About Data Grids
  • 2.7.2 Creating a Data Grid
  • 2.7.3 Copying a Data Grid
  • 2.7.4 Viewing and Editing a Data Grid
  • 2.7.5 Viewing the Data Grid Change History Log
  • 2.7.6 Deleting a Data Grid
• 2.8 About Adding and Editing Data Content
  • 2.8.1 About Available Data Sources
  • 2.8.2 About Enabling Support for Creating Data Reports
  • 2.8.3 About Incorporating Data into Websheet Pages
• 2.9 About Adding Data Reports
  • 2.9.1 About Data Reports
  • 2.9.2 Creating a Data Report
  • 2.9.3 Viewing and Modifying a Data Report
  • 2.9.4 Deleting a Data Report
• 2.10 About Data Sections
  • 2.10.1 Adding a Data Section to a Page
  • 2.10.2 Editing a Data Section
• 2.11 About Chart Sections
  • 2.11.1 Adding a Chart Section
  • 2.11.2 Editing a Chart Section
• 2.12 About PL/SQL Sections
  • 2.12.1 Adding a PL/SQL Section
  • 2.12.2 Editing a PL/SQL Section
• 2.13 Understanding Markup Syntax
  • 2.13.1 Linking to a Page
  • 2.13.2 Linking to a Section
  • 2.13.3 Linking to External URLs
  • 2.13.4 Linking to a Data Grid
  • 2.13.5 Using SQL and SQLVALUE Syntax
  • 2.13.6 About Advanced Data Grid Queries Rules
• 2.14 Managing Annotations
  • 2.14.1 Managing Uploaded Files and Images
  • 2.14.2 Adding Tags
  • 2.14.3 Adding Notes
  • 2.14.4 Viewing and Deleting Annotations
• 2.15 Managing Websheet Applications
  • 2.15.1 Changing Your Websheet Password
  • 2.15.2 Emailing a Websheet Page
  • 2.15.3 Printing a Websheet Page
• 2.16 Viewing Websheets
  • 2.16.1 About Presentation Mode
  • 2.16.2 Viewing the Page Directory
  • 2.16.3 Viewing Page History
  • 2.16.4 Viewing the Websheet Directory

3 Using Interactive Reports

• 3.1 Running an Interactive Report
• 3.2 What is 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 the Actions Menu
  • 3.6.1 About the Actions Menu
  • 3.6.2 Selecting Columns to Display
  • 3.6.3 Adding a Filter
  • 3.6.4 Specifying Rows Per Page
  • 3.6.5 Selecting Column Sort Order
  • 3.6.6 Creating a Control Break
  • 3.6.7 Adding Highlighting
  • 3.6.8 Computing Columns
  • 3.6.9 Aggregating a Column
  • 3.6.10 Creating a Chart from the Actions Menu
  • 3.6.11 Grouping Columns
  • 3.6.12 Executing a Flashback Query
  • 3.6.13 Saving an Interactive Report
  • 3.6.14 Resetting a Report
  • 3.6.15 Downloading a Report
  • 3.6.16 Subscribing to Emailed Reports

4 About Uploading Data

• 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
• 4.4 Automatically Supported Date, Timestamp and Number Formats

Index