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
- 4323 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 are the different types of database objects?
How would you change old and new values in an insert, delete and update triggers?
What is Virtual Private Database in Oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is open database communication (odbc) in oracle?
What is oracle thin client?
What is the fastest query method to fetch data from the table?
What types of joins are used in writing subqueries?
How to create a temporary table in oracle?
Does oracle database need java?
Can we protect our pl/sql source code?
How view is different from a table?
How to run create database statement again?
What is oracle database client?
What is an external table?
