Skip Headers
Oracle® Airlines Data Model Reference
11g Release 2 (11.2)

Part Number E26208-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub
DMARF1227

10 Oracle Airlines Data Model Utility Scripts

This chapter describes the Oracle Airlines Data Model utility scripts.

This chapter includes the following sections:

DMARF1228

Calendar Population

The Calendar population scripts consist of two one-time installation packages.

DMARF1229

Calendar Population Scripts

The Calendar population scripts include the following packages:

  • calendar_population_header.sql

  • calendar_population_body.sql

Running these packages does the following:

  1. Prepares necessary changes for the OADM_SYS schema.

  2. Creates the Calendar_Population package that contains the following procedures:

    • RUN(in_setup_start_date, in_setup_no_years) is the main procedure to populate everything about calendar.

    • RBIW_Base_Time_Tables_ddl creates the base table needed to support multiple hierarchies: Business or Calendar.

    • RBIW_Populate_Time_Hier_Bsns(in_setup_start_date, in_setup_no_years) sets up the data in base table for the Business hierarchy as specified in setup or install section.

    • RBIW_Populate_Time_Hier_Clndr(in_setup_start_date, in_setup_no_years) sets up the data in base table for the Calendar hierarchy as specified in setup or install section.

    • RBIW_Time_hier_Star sets up the Time hierarchy reporting layer tables.

    • RBIW_Time_Views sets up the Time hierarchy reporting layer views, star and hybrid snowflake views.

    • RBIW_Populate_Time_Transform populates the Time transformation tables using the base Time tables or views created above. It populates transformation data for both hierarchies: Business and Calendar.

DMARF1230

How to Populate Calendar Data

To populate calendar data:

  1. Log in to OADM_SYS user.

  2. Execute the following SQL statement:

    exec Calendar_Population.run(date,num_years);
    

    where, date is the start date with which you want to populate calendar data. It is of type CHAR and should be input in the format 'YYYY-MM-DD' (for example,'2005-05-18'). num_years is the number of years to populate calendar data, which should be INTEGER.

Reader Comment

   

Comments, corrections, and suggestions are forwarded to authors every week. By submitting, you confirm you agree to the terms and conditions. Use the OTN forums for product questions. For support or consulting, file a service request through My Oracle Support.

Hide Navigation

Quick Lookup

Database Library · Master Index · Master Glossary · Book List · Data Dictionary · SQL Keywords · Initialization Parameters · Advanced Search · Error Messages

Main Categories

This Page

This Document

New and changed documents:
RSS Feed HTML RSS Feed PDF