VARIABLE ONE TO ONE RELATION:
ID ADDRESS
1
2
PHONE
ID NUMBER
3
4
EMP
ID C_ID(EMAILID,PHONEID)
01 1
02 2
03 4
WHAT KIND OF CONSTRAINT I SHOULD PUT ON C_ID IN EMP TABLE SO THAT IT REFERENCE TO EITHER PHONE OR EMAIL;
Printable View
VARIABLE ONE TO ONE RELATION:
ID ADDRESS
1
2
PHONE
ID NUMBER
3
4
EMP
ID C_ID(EMAILID,PHONEID)
01 1
02 2
03 4
WHAT KIND OF CONSTRAINT I SHOULD PUT ON C_ID IN EMP TABLE SO THAT IT REFERENCE TO EITHER PHONE OR EMAIL;
I am not aware of any one constraint that can do this. May be someone else has any idea.
I would suggest writing an After Update and Insert trigger on that column to check the values.
- Rajeev
thanks rsuri,
can you give an eg.
thanks aain