|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
checking participation constraint
I wanted to know how can I check participation constraint for a one to man relationship in oracle.
Suppose an employee works in a department. There can be many employees working in a department. For a department, there has to be atleast one employee. i cannot write - foreign key (dept) references employee. Then it wil be one to one relationship. Secondly I cannot write assertions or domains in ORACLE. Can somebody please tell me what is the procedure followed for checking this constraint? |
|
#2
|
|||
|
|||
|
desdc user_constraints and user_cons_columns...it will all be in there. if you have privs check dba_constraints as well.
~jimbag8 |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > checking participation constraint |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|