Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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?

Comments

495335
I've found some information that looks helpful, in the form of a blog entry found at:

http://forms.pjc.bean.over-blog.com/article-3234108.html

The entry mentions that the bean cannot be registered immediately within the WHEN_NEW_FORM_INSTANCE trigger, and shows how to delay this slightly using a timer.

Special thanks to Francois Degrelle for the blog entry linked above, and to Frank Nimphius, for the blog entry that pointed me there! :)

Eric Adamson
Lansing, Michigan
495335
I've discovered what my problem was, and it was silly. I had updated the archive_jini entry that appears in my webutil config, but in this case, I was not specifying that config when calling frmservlet, so the JAR was not being downloaded. (DOH!)

Eric
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 19 2007
Added on Feb 14 2007
14 comments
5,388 views