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
- 4482 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
How to sort output in descending order in oracle?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How to use fetch statement in a loop?
how to do daily transactions with out sql* loader control file regesterd in apps?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
Can we use bind variables in oracle stored procedure?
what are the default admin accounts in Oracle 10g ?
How view is different from a table?
How to import one table back from a dump file?
How to retrieve values from data fields in record variables?
How to define a data field as not null?
How to calculate date and time differences in oracle?
How to use select statement to count the number of rows in oracle?
What is a database schema in oracle?
How a tablespace is related to data files?
