Hi,
Actually what I mean is "Overlap"=> the new value of start & end code should not be in the range of the existing values.
For Ex:
#1. Start = 30 & End = 90
If I give start as 40 and end as 80 it should not return a row.
Its not only the number the column is alphanumeric. If the user is entering alphanumeric for these two fields then how can we change...
moorthyvisu
Last Activity: Nov 6 '07, 10:29 PM
Joined: Nov 1 '07
Location:
-
how to compare value of two varchar2 fields ?
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,... -
Queries in Oracle & SQl server.
Hi All,
I need the basic information about how the query is working in Oracle & SQl Server.
Sicne I am getting different values when I run the query. I have a table called 'Client_Master' in both the DB
(ie., Oracle & SQL). I have inserted a record with the below values for Client_Master table. (both Oracle & SQl).
Inserted Values:
----------------
Start_Code = 90
...
No activity results to display
Leave a comment: