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
- 3507 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 |
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What is the difference between Sleep and Wait? (Java)
What is a read write transaction in oracle?
what is primary key and foreign key when and where have to use
create one table to capture an employee details with a primary key.
Please explain the difference between outer join and inner join? With examples would be appreciable..!
What are the tools for Oracle ?
Hi Can any one tell me what are the API's used in requisition import.
What is a trigger and what are its types?
How to delete multiple rows from a table in oracle?
What are the differences between char and nchar in oracle?
Define the terms primary key foreign key and also the difference between primary and the unique key
Oracle General 
