its urgent please help........

[el472]

VARIABLE ONE TO ONE RELATION:
EMAIL
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;

[rsuri]

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

[el472]

thanks rsuri,
can you give an eg.

thanks aain