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
- 4493 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 |
How do I use unicode codesets with the weblogic jdriver for oracle driver?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the restrictions on external table columns?
How to add another datafile to a tablespace?
which is best insttute for teradata,sybase,mysql,oracle in hyderabad
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately
What would you use to improve performance on an insert statement that places millions of rows into that table?
Explain about functional dependency and its relation with table design?
When system tablespace is created?
How to list all indexes in your schema?
What is tablespace in oracle? how can we create? how is it manage? . . . Thnx 2 All in Advnc....:)
Oracle General 
