Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Constraint question - maybe simple?
I have a table TRAIN with several fields, and the three ones of
importance are:
The primary key is on TRAIN_I and P_VERSION_I.
Is it possible to add a constraint such that there can be several pairs of (TRAIN_I, TRN_SYMBOL_I) but they must match? What I mean is, if there is one record with TRAIN_I = 123, and TRN_SYMBOL_I = ABC, and we add another record with TRAIN_I = 123 (and a different P_VERSION_I of course), then it is constrained to have TRN_SYMBOL_I = ABC?
I can't think of a simple way, although I am a beginner here.
Thanks,
Dean Received on Mon Oct 24 2005 - 10:59:11 CDT
![]() |
![]() |