Skip to Main Content

Java Development Tools

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!

validation rule : check for overlapping dates

110997Oct 20 2006 — edited Jun 28 2007
hi,

I have 2 columns, a start date and and end date, I want to create a validation rule that will check if the above columns in a new or updated row does not overlap with any other record in the table. How do I do that?

I've already implemented a validation rule that checks if the start date is earlier than the end date and it works fine.

Thanks,
alfredo
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 26 2007
Added on Oct 20 2006
7 comments
1,550 views