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
- 4461 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
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is recovery manager in Oracle?
Explain the difference between a procedure and a function?
What is meant by joins?
Explain oracle insert into command?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to create a new table in oracle?
What is background process in Oracle?
What is Virtual Private Database in Oracle?
What is hot backup and logical backup?
What are a query and state the different types of queries and their uses?
Name the various constraints used in oracle?
What is a user account in oracle?
Is primary key indexed by default in oracle?
Explain what are synonyms used for?
