Databases Reference
In-Depth Information
Figure 11-36.
Creating the list of suggested database objects
Not
■
When you set Allow sQL and pL/sQL to Yes, you're giving contributors access to all the database objects in
the websheet's default schema. This is a potentially serious security issue. it's imperative that you chat with your Oracle
database Administrator (dbA) before you use this feature to make sure sensitive data isn't accidentally exposed.
Reports: Creation
After you've set up the Allow SQL and PL/SQL feature in the Application Builder, return to your websheet. You create a
report by selecting New Report from the Report menu (see Figure
11-37
) or clicking the Create Report button from the
View All report.
Figure 11-37.
Choosing the New Report option
The Create Report page prompts you for one of two report sources (see Figure
11-38
). The Table report source
creates a report that contains all the columns in the selected table or view. The SQL Query report source
(see Figure
11-39
) creates a report based on a SQL statement. Using a SQL statement gives you a tremendous amount
of flexibility in tailoring a report to your needs. In both cases, click Next to go to a confirmation page and check your
input before creating the report.
