Check Constraint Question
From: jaimin saraiya <jsaraiya_at_hotmail.com>
Date: 17 Jul 2001 08:46:47 -0700
Message-ID: <abb3ac41.0107170746.2b4fb5e7_at_posting.google.com>
Date: 17 Jul 2001 08:46:47 -0700
Message-ID: <abb3ac41.0107170746.2b4fb5e7_at_posting.google.com>
Hello All,
Situation:
Table 1:
FIELD TYPE
A VARCHAR2 B VARCHAR2
TABLE 2
C VARCHAR2
D VARCHAR2
I need to put a check constraint on TABLE1 FIELD B so that
VALUE OF B must be in TABLE2 FIELD D FOR FIELD C = 'DUMMY'
I know ORACLE does not allow subqueries in CHECK Constraints, Is there any other way to solve this?
Thank you!
Jaimin Received on Tue Jul 17 2001 - 17:46:47 CEST