Database Reference
In-Depth Information
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
The bottom region of the page allows you to list all objects that will be created by
the supporting object-installation scripts. At installation time, if any of the listed ob-
jects already exist, the install won't proceed, because there could be a clash. The user
installing the application is given the details of which objects are found to already ex-
ist.
This section may seem a bit limiting in its scope, but the Validation section, dis-
cussed later, allows for more free-form prerequisite checks.
Substitutions
This section provides the ability to allow the installing user to define the value for
application-level substitution strings at install time. Although substitution strings are
meant to be used like static variables, you may not always know what the value of
these strings should be prior to installation. From this interface you can choose which
substitution variables you want to let the installing user define, and what the prompt for
each variable should be.
Substitution variables aren't used very often, so this feature is also unlikely to be
used. However, it's good to know that it's there if you need it.
Build Options
We spoke about build options and the fact that they can be used to exclude or hide as-
signed functionality. This section allows you to select whether build options you've
defined are available to the installing user. By selecting a build option, the user will be
prompted whether they wish to include or exclude the functionality associated with the
build option.
Most of the time, when moving applications to production, you want to exclude all
build options.
Validations
