5.7 About Adding and Editing Data Content

This section describes how to add and edit data content.

Topics:

Available Data Sources
About Enabling Support for Creating Data Reports
Incorporating Data into Websheet Pages

5.7.1 Available Data Sources

Websheets can include data sources. Once defined, you can incorporate these data sources into Websheet page sections. Websheets can include the following data sources:

Data Grids - Data grids are highly customizable, editable tabular reports. Data grids enable you to maintain data within the Websheet which is stored within the Oracle database. See "About Adding Data Grids".
Reports - Reports are queries defined against tables or views that exist within your Oracle database. See "About Adding Data Reports".

5.7.2 About Enabling Support for Creating Data Reports

To define a data report, your Websheet developer must enable the Allow SQL and PL/SQL attribute on the Websheet Properties page. By default, this attribute is disabled.

Tip:

Only a Websheet application developer can edit the Allow SQL and PL/SQL attribute on the Websheet Properties page. To learn more, see "Editing Websheet Properties"

5.7.3 Incorporating Data into Websheet Pages

Data grids and data reports can be incorporated into page sections in the following ways:

Within a data section. See "About Adding Data Reports".
Within a chart section. See "Adding a Chart Section".
Linking to a Data Grid. See "Linking to a Data Grid".
Include a single value or tabular results of queries See "Using SQL and SQLVALUE Syntax".