Contents

Title and Copyright Information

Preface

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

1 About Oracle Application Express

• About Oracle Application Express
• About Websheet Applications
• About Database Applications
• About Browser Requirements

2 Using Websheets

• Running a Websheet
• About Using Websheets
  • Using Breadcrumbs and Navigation Sections
  • About the Help Link
  • About the Logout Link
  • About Websheet Search
  • About the Control Panel
• Managing Websheet Pages
  • Adding a New Page
  • Copying an Existing Page
  • Editing Page Details
• About Adding and Editing Page Sections
  • About Section Types
  • About Editing Sections
  • Deleting Page Sections
  • Editing Section Titles and Display Order
• About Text Sections
  • Adding a Text Section
  • Editing a Text Section
• About Navigation Sections
  • Adding a Navigation Section
• About Adding Data Grids
  • About Data Grids
  • Creating a Data Grid
  • Copying a Data Grid
  • Viewing and Editing a Data Grid
  • Viewing the Data Grid Change History Log
  • Deleting a Data Grid
• About Adding and Editing Data Content
  • About Available Data Sources
  • About Enabling Support for Creating Data Reports
  • About Incorporating Data into Websheet Pages
• About Adding Data Reports
  • About Data Reports
  • Creating a Data Report
  • Viewing and Modifying a Data Report
  • Deleting a Data Report
• About Data Sections
  • Adding a Data Section to a Page
  • Editing a Data Section
• About Chart Sections
  • Adding a Chart Section
  • Editing a Chart Section
• About PL/SQL Sections
  • Adding a PL/SQL Section
  • Editing a PL/SQL Section
• Understanding Markup Syntax
  • Linking to a Page
  • Linking to a Section
  • Linking to External URLs
  • Linking to a Data Grid
  • Using SQL and SQLVALUE Syntax
  • About Advanced Data Grid Queries Rules
• Managing Annotations
  • Managing Uploaded Files and Images
  • Adding Tags
  • Adding Notes
  • Viewing and Deleting Annotations
• Managing Websheet Applications
  • Changing Your Websheet Password
  • Emailing a Websheet Page
  • Printing a Websheet Page
• Viewing Websheets
  • About Presentation Mode
  • Viewing the Page Directory
  • Viewing Page History
  • Viewing the Application Directory

3 Using Interactive Reports

• Running an Interactive Report
• What is an Interactive Report?
• Using the Column Heading Menu
• Using the Search Bar
  • Using the Select Columns To Search Icon
• Using the Actions Menu
  • About the Actions Menu
  • Selecting Columns to Display
  • Adding a Filter
  • Specifying Rows Per Page
  • Selecting Column Sort Order
  • Creating a Control Break
  • Adding Highlighting
  • Computing Columns
  • Aggregating a Column
  • Creating a Chart from the Actions Menu
  • Grouping Columns
  • Executing a Flashback Query
  • Saving an Interactive Report
  • Resetting a Report
  • Downloading a Report
  • Subscribing to Emailed Reports

4 About Uploading Data

• About Using the Data Loading Wizard
• Importing Data from a File into Your Application
• Copying and Pasting Data into Your Application
• Automatically Supported Date, Timestamp and Number Formats

Index