Hi,
I have a below scenario:
Table name : ClientCode.
Fields are : startcode varchar2(20) & endcode varchar2(20);
The values in these two fields should not overlap.
For Ex:
#1. startcode = 50 & endcode = 110 - this is allowed
#2. startcode = 130 & endcode = 180 - this is allowed
#3. startcode = 90 & endcode = 100 - this should not allow, since the values are
overlapped.
I would highly appreciate if any one can post the query to resolve this issue.
Thnx in advance.