|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 can be used if holidays (or any other exception) must be taken into account, and to ensure that dates are within a boundary.