Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Checking for Overlaping Date Range
Hi All,
In my program, the users need to enter two dates which represent the vacation range, which, supposedly, not to overlap with other vacation ranges. If there is vacations in the databases, I can check the newly input data against them. However, if there is not, i have to check the ranges record by record before i commit them. Then the problem comes:-
Then what should i do? Pls rescue me! :P Thanks in advance!!!
Thenard
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Sat Jan 17 1998 - 00:00:00 CST