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
- 4583 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the quickest way to export a table to a flat file?
What is ordinary table in oracle?
How to write numeric literals in oracle?
How to create a new view in oracle?
Can we create trigger on materialized view in oracle?
What is a tns service name?
Why does Oracle not permit the use of PCTUSED with indexes?
What is where clause in oracle?
What is transaction control statement and how many types of transaction control statement in Oracle?
What is a schema in oracle?
what is the difference between functional dependecy and multilevel dependency?
What is the difference between the Oracle ODBC driver and a Microsoft ODBC (Open Database Connectivity) Driver?
What is format trigger?
What is a static data dictionary in oracle?
How view is different from a table?
