Database Reference
In-Depth Information
CHAPTER 12
A Websheet Example
The previous chapter covered many of the different features in websheets. In this
chapter, you use these features to build an application from scratch.
The example application manages a corporate soccer team. Currently, the player
roster and schedules are maintained in spreadsheets. When the schedule is updated, the
spreadsheet is e-mailed to all the players. As you can imagine, it would be very frustrat-
ing to manage a team this way.
A websheet is a good way to manage the soccer team because websheets can be built
with minimal developer or DBA assistance. All the files, along with a copy of the final
application, can be found in the example download described in the introduction to this
book.
Setup
In order to highlight the capability of websheets to interact with objects in your data-
base, let's create some database objects that are referenced throughout the chapter. These
objects simulate an existing users table and login function for your organization:
1.
Run the following code, which is included in the example download as a
script named
ch12_database_objects.sql
, in SQL*Plus or directly
in APEX using the SQL workshop:
-- Create Users Table
CREATE TABLE tusers (
user_id
NUMBER (5, 0) PRIMARY KEY,
user_name
VARCHAR2 (10) NOT NULL UNIQUE,
