Skip to Main Content

SQL support for Time periods and handling history tables, etc.

331961Feb 14 2007 — edited Feb 19 2007
Beyond the standard SQL datatype DATE and operators/functions like <,=,>, LEAST, GREATEST, etc. (and in 10g the new INTERVAL data types) does Oracle offer anything to help handle time period based data on multiple tables? E.g. for overlapping time periods, joins when gaps in time periods, period contiguity checks, gap finding, etc. I've developed various SQL query techniques, but they're all rather cumbersome using standard SQL. Oracle Spatial offers geo-location support but is there anything similar for temporal query support?
Or any good books / articles on the subject?
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Mar 19 2007
Added on Feb 14 2007