Interested to Buy Any Domain ? << Click Here >> for more details...
Hi how Can I Add A Foreign key that references a table that
has composit primary key ?
example i had costumer table that has C_Id and SSN Both as
PK and another table has C_Id that must refernece C_Id in
Customers i done the usual way and got oracle error message
about uniqeness any ideas plz
- 2 Answers
- 4369 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manish yadav
Problem:I think you are challenging the concept of foriegn
key here, a forign key should be unique or primary key in
the refrenced table,C_ID in your case is part of composite
key i.e. its not primary key itself and nither unique key.
Solution:In customer table you may not want to change
primary key but if possible add unique constraint on C_ID
column. It should work
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mrs.priya
try to separate the composite key using str function when
referencing in another function to get only C_ID
| Is This Answer Correct ? | 0 Yes | 0 No |
does the query needs a hint to access a materialized view?
Define oracle database
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
What are the parameters that we can pass through a stored procedure?
How view is different from a table?
What is partitioned table in Oracle?
How many types of tables supported by oracle?
Explain can a view based on another view?
What are transaction isolation levels supported by oracle?
Explain the use of compress option in exp command.
What privilege is needed for a user to create tables in oracle?
what is trigger?
Oracle General 
