René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback

Oracle Time Series


Run ?/ord/admin/ordinst.sql as sys
Oracle Time Series is installed in ORDSYS's schema, if you don't want to prefix every datatype and package with ORDSYS, you might want to create the following public synonyms:
create public synonym timeseries for ordsys.timeseries;
create public synonym calendar   for ordsys.calendar;
create public synonym tstools    for ordsys.tstools;
create public synonym timescale  for ordsys.timescale;

Calendar vs Non-calendar

Calendars allow to perform the analytical functtion lead and lag.
Calendars can be used if holidays (or any other exception) must be taken into account, and to ensure that dates are within a boundary.