Defining View Programs

This section includes information on:

• Creating Source Code for a View Program
• About View Table Instances
• About Table Descriptors in View Programs

The View-type Program creates a database view of data in multiple Table instances. When you install the View Program, the system creates a Table definition, a Target Table Descriptor and a Table instance object of type View; and maps the Table instance to the target Table Descriptor.

The resulting View Table instance created in the Work Area schema functions like any database view and always displays current data available in the source Table instances. You can combine data from various Table instances without storing the data multiple times in the database. Other Programs, Business Areas and Data Marts can also read from the View Table instance. View-type Programs cannot be executed and therefore you cannot create them under a Report Set or Workflow.

The status of a View Program is 'Installable' if the View Program contains both a Source Code and a source Table Descriptor. The View Program's Launch IDE behavior is the same as that of a PL/SQL Program.

• Creating Source Code for a View Program
  When you launch the View Program, the system launches its primary source code file.
• About View Table Instances
  You can only create a View Table instance by installing a View Program. You cannot create or update a View Table instance from the Oracle Life Sciences Data Hub User Interface or through APIs. Once created, the target Table Descriptor cannot be unmapped from its Table instance.
• About Table Descriptors in View Programs
  You cannot map source Table Descriptors of a View Program to a View Table instance.